Adding months onto a date

Hi sorry I have seen this posted multiple times before but I can't get mine to work.


I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column.


I have tried this formula:

=DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row) + ([Monthly Review Frequency]@row), DAY([Previous Review Date]@row))


However this only works for for dates where the year would not change.


Thank you for your help in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!