Formula to show a reminder

[Saturn]

I try to write a formula which will show a reminder in a cell,
on and after the time and date I write in the 'input' cells.
It seems that there is nothing wrong with the formula structure but
something is wrong as the message appears before the indicated time.
Please see the attached file.

[AlexandraT]

Remove from the formula the following: YEAR(), MONTH(), DAY(), HOUR(), MINUTE(). Your current formula is trying to evaluate year(2016) and so on. You only need the cells in this case, since you have all the info in separate cells:

Please Login or Register  to view this content.

FYI: You can always see how a formula works (or why it doesn't) if you select the cell with the formula, go to the FORMULAS tab and click "Evaluate formula" in the "FormulaAuditing" section.

Alex

[samba_ravi]

=IF(NOW()>DATE(H6,G6,F6)+TIME(F8,G8,),"Do this, do that","")
try this

[Saturn]

Thanks a lot Alex.
I often use the FormulaAuditing, but I didnt in this case. Also thanks for the corrections with regard to DATE and TIME.

But the formula still doesnt work as intended as the message appears the (right) day in question but even BEFORE the right time, (hour and minute).

[AlexandraT]

Please Login or Register  to view this content.

Same as nflsales suggests.

Alex

[Saturn]

This thread is reopened.
Please see the new attachement.
I would like to have a formula which refers to one singel cell, which is in customized format, similar to the NOW function.
Is it possible ?

[cbatrody]

Hi,

Try the following in D9:

=IF(NOW()>D15,"Do this, do that","")