Adding Months to a Date
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!