Previous Topic Next Topic

Excel reminder

Closed
Tricia Kozuki Posts 2 Registration date Sunday 23 June 2013 Status Member Last seen 27 June 2013 - 23 Jun 2013 à 22:09
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 24 Jun 2013 à 11:44
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!!
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
24 Jun 2013 à 11:44
Hi Tricia,

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

Best regards,
Trowa

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses