Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today.
For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
Answers
-
Hi @Haley Lavender,
I would suggest using a column that has the contract start date and use that static date to determine 1 year later. There is a TODAY() formula that can be used but it will continually change your value as "today" changes.
So, the Earliest Possible Termination Date column could use the following column formula.
=[Contract Start Date]@row + 365
Hope this helps,
Dave
-
Hi @DKazatsky2, thank you for your response! I am very interested in learning the TODAY() formula that will continually change value as "today" changes -- that's actually what I'm needing to accomplish in my sheet. Could you please share how you'd use that formula?
-
All you need to do is use TODAY() in any formula. So to get the date in one year you would use =TODAY() + 365.
Best of luck,
Dave
-
=DATE(YEAR(TODAY())+1, MONTH(TODAY()), DAY(TODAY()))
This way is a little more flexible, can do with months or days too but here you have format to do any.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!