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


  • Genevieve P.
    Genevieve P. Employee Admin


    How about translating the months into days, then simply adding that number of days on to the date, like so:

    =[Previous Review Date]@row + ([Monthly Review Frequency]@row * 30)

    It won't be exactly on the same day of the month 6 months from that date, but it will translate the year correctly. Let me know if this would work for you!



    Answer ✓

    HI Genevieve,

    thanks for your help, however the dates weren't very accurate for the next review date. I have figured it out myself however using helper rows!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!