Warning to come up if today surpasses a certain date
Closed
Matty134
Posts
1
Registration date
Monday 19 May 2014
Status
Member
Last seen
19 May 2014
-
19 May 2014 à 03:57
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 May 2014 à 11:47
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 May 2014 à 11:47
Related:
- Warning to come up if today surpasses a certain date
- How to remove the security warning on internet explorer - Guide
- Pc restarts without warning - Guide
- Warning cmos checksum error - Guide
- Google maps speed camera warning - Guide
- Facebook account disabled without warning - Facebook Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
19 May 2014 à 11:47
19 May 2014 à 11:47
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
