HELP!! Excel 3 year reminder

Closed
Report
Posts
2
Registration date
Sunday June 23, 2013
Status
Member
Last seen
June 27, 2013
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
I have a formula: =TODAY()-$B2>3, this will remind me 3 days before a due date, but I need it to tell me to review after 3 YEARS of the dates I have in B2. Someone on here told me to replace TODAY with YEAR and it doesn't work.

HELP!

Thank you :)

2 replies

year(today())-year($B2)>3
0
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hey, that someone is me. And I said "put year in front" instead of replace.

Try responding next time instead of creating a new thread.

Thank you.
0