Dates formula : add several months in a formula
Hello everyone,
I have a small question about the use of Smartsheet for a formula on dates. Here is the use case :
I have a column with a date. I would like to have another column with a formula that add 3 months to that date.
I already try =DATE(column)+90 but it only add 90 days and sometimes 90 days is not exactly a 3 months duration. Do you know if it is possible in Smartsheet ?
Thank you very much,
Corentin
Best Answer
-
You should be good with:
=IFERROR(DATE(YEAR([Date]@row, MONTH([Date]@row)+3, YEAR([Date]@row)), DATE(YEAR([Date]@row +1 , MONTH([Date]@row)-9, DAY([Date]@row)))
Hope it helped!
Answers
-
You should be good with:
=IFERROR(DATE(YEAR([Date]@row, MONTH([Date]@row)+3, YEAR([Date]@row)), DATE(YEAR([Date]@row +1 , MONTH([Date]@row)-9, DAY([Date]@row)))
Hope it helped!
-
Hello @David Joyeuse
It works perfectly, thank you very much for your help on this pain point !
Have a great day,
Corentin
-
I'm trying to do the exact same thing and it keeps saying incorrect argument. My first date column was "date hired" so I changed [date] to [date hired] and my second column is labelled 3 month mark. @David Joyeuse im stuck any help would be appreciated
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!