Excel reminder

Closed
Posts
2
Registration date
Sunday June 23, 2013
Status
Member
Last seen
June 27, 2013
-
Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
-
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!!

1 reply

Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
491
Hi Tricia,

Put YEAR in front of TODAY like =YEAR(TODAY())...

Best regards,
Trowa