Previous Topic Next Topic

HELP!! Excel 3 year reminder

Closed
Tricia Kozuki Posts 2 Registration date Sunday June 23, 2013 Status Member Last seen June 27, 2013 - Jun 27, 2013 at 08:30 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 2, 2013 at 11:43 AM
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 :)
Related:

2 responses

Answer 1 / 2
LynxDeuxJynx
Jul 1, 2013 at 05:22 AM
year(today())-year($B2)>3
0
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jul 2, 2013 at 11:43 AM
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