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?

Devin Lee

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)))

Devin Lee

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)))

EvieSummit

This works!! I also had to change my column type to a date column, now it works like a charm! Thank you so much!