# Adding Months to a Date

Options

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:

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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)))
```
• Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!