Adding months onto a date

Options
JPFORDTE
JPFORDTE ✭✭
in Formulas and Functions

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


image.png

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:

image.png

=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!

Tags:
· Share on FacebookShare on Twitter

Best Answer

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @JPFORDTE

    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!

    Cheers,

    Genevieve

    · Share on FacebookShare on Twitter
  • JPFORDTE
    JPFORDTE ✭✭
    Answer ✓
    Options

    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!

    image.png
    image.png


    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!