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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 19, 2014 at 11:47 AM
Related:
- Warning to come up if today surpasses a certain date
- Google maps warning symbols - Guide
- Warning: potential security risk ahead firefox disable - Guide
- Firestick low battery warning - Guide
- Warning cmos checksum error - Guide
- Please press f1 key skip warning message or delete key enter setup - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 19, 2014 at 11:47 AM
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
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
