Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work.
I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column.
I have tried this formula:
=DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row) + ([Monthly Review Frequency]@row), DAY([Previous Review Date]@row))
However this only works for for dates where the year would not change.
Thank you for your help in advance!
Best Answer
-
HI Genevieve,
thanks for your help, however the dates weren't very accurate for the next review date. I have figured it out myself however using helper rows!
Answers
-
Hi @JPFORDTE
How about translating the months into days, then simply adding that number of days on to the date, like so:
=[Previous Review Date]@row + ([Monthly Review Frequency]@row * 30)
It won't be exactly on the same day of the month 6 months from that date, but it will translate the year correctly. Let me know if this would work for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
HI Genevieve,
thanks for your help, however the dates weren't very accurate for the next review date. I have figured it out myself however using helper rows!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!