Formula to automatically calculate 3 years from a date in another cell
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
Best Answer
-
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
Answers
-
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))
-
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
-
This one worked thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!