Warning to come up if today surpasses a certain date

Closed
Matty134 Posts 1 Registration date Monday May 19, 2014 Status Member Last seen May 19, 2014 - May 19, 2014 at 03:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 19, 2014 at 11:47 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 19, 2014 at 11:47 AM
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
0