Adding Months to a Date
EvieSummit
✭✭✭
Hello! I've been hunting and cannot find a solution to a problem that shouldn't be complicated.
I need to add a varying number of months to a date, and spit out a new date. Specifically: Date Opened + MTE = Expected Completion Date. For the life of me I cannot get it to work. Any ideas?
Tags:
Best Answer
-
Hey @EvieSummit
Most likely there are issues around jumping from one year to another. Try something like this:
=IF(MONTH([Date Opened]@row) + [MTE (Months)]@row > 12, DATE(YEAR([Date Opened]@row) + 1, MONTH([Date Opened]@row) - (12 - [MTE (Months)]@row), DAY([Date Opened]@row)), DATE(YEAR([Date Opened]@row), MONTH([Date Opened]@row) + [MTE (Months)]@row, DAY([Date Opened]@row)))
Answers
-
Hey @EvieSummit
Most likely there are issues around jumping from one year to another. Try something like this:
=IF(MONTH([Date Opened]@row) + [MTE (Months)]@row > 12, DATE(YEAR([Date Opened]@row) + 1, MONTH([Date Opened]@row) - (12 - [MTE (Months)]@row), DAY([Date Opened]@row)), DATE(YEAR([Date Opened]@row), MONTH([Date Opened]@row) + [MTE (Months)]@row, DAY([Date Opened]@row)))
-
This works!! I also had to change my column type to a date column, now it works like a charm! Thank you so much!
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!