Warning to come up if today surpasses a certain date [Closed]

Report
Posts
1
Registration date
Monday May 19, 2014
Status
Member
Last seen
May 19, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Any ideas what is wrong with this formula? I want the warning to come up if today surpasses a certain date. It is to warn me of when permits need to be looked at again. The formula below is what I have been using so far.

=IF(TODAY>=1/10/17,"Attention","Not Yet")

Any ideas?

Cheers

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Matty134,

Two things need to be adjusted:
1) It's TODAY() instead of TODAY. Otherwise the function is incomplete.
2) It's "1/10/17" instead of 1/10/17. Otherwise Excel applies math instead of seeing it as a date.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!