Excel reminder
Closed
Tricia Kozuki
Posts
2
Registration date
Sunday June 23, 2013
Status
Member
Last seen
June 27, 2013
-
Jun 23, 2013 at 10:09 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 24, 2013 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 24, 2013 at 11:44 AM
Hello...I need to create a reminder for dates in B2 that is 3 years after the date in B2. To have B3 highlight with REVIEW would be great. I have a formula but it's for days: =TODAY()-B2>1056. This works but I'd feel better with it being in year format.
Thank you!!
Thank you!!
Related:
- Excel reminder
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 24, 2013 at 11:44 AM
Jun 24, 2013 at 11:44 AM
Hi Tricia,
Put YEAR in front of TODAY like =YEAR(TODAY())...
Best regards,
Trowa
Put YEAR in front of TODAY like =YEAR(TODAY())...
Best regards,
Trowa