Adding months (stipulated in one cell) to a date (stipulated in another cell)

Options

I have used this formula:

=DATE(IF(MOD(VALUE(MONTH([Date Approved]@row)) + MTE@row, 12) = 0, -1, 0) + YEAR([Date Approved]@row) + (MONTH([Date Approved]@row) + MTE@row - MOD(MONTH([Date Approved]@row) + MTE@row, 12)) / 12, IF(MOD(VALUE(MONTH([Date Approved]@row) + MTE@row), 12) = 0, 12, MOD(MONTH([Date Approved]@row) + MTE@row, 12)), DAY([Date Approved]@row))

But I get #INVALID COLUMN VALUE

The Date Approved is formatted as a Date Type but the Months cannot be a date value

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!