Formula to automatically calculate 3 years from a date in another cell

vclout

I want to create a formula to automatically calculate 3 years from a date in another cell so that I know when something has to be renewed. Any advice

Gregory Watt

This is what I do for notifications.

Future Colum Cell =[Your Date Row]@row + 1095

Due Colum Cell =[Your Future Cell]@row - TODAY()

Then I run a notification email once a week, where Date Until/Over - Is less than

Paul Newcome

You should be able to use something along the lines of...

=DATE(YEAR([Original Date Column]@row) + 3, MONTH([Original Date Column]@row), DAY([Original Date Column]@row))

Gregory Watt

This is what I do for notifications.

Future Colum Cell =[Your Date Row]@row + 1095

Due Colum Cell =[Your Future Cell]@row - TODAY()

Then I run a notification email once a week, where Date Until/Over - Is less than

vclout

This one worked thanks!