Adding months onto a date

10/27/21
Accepted

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

  • JPFORDTEJPFORDTE
    Accepted 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!


Answers

  • 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

  • JPFORDTEJPFORDTE
    Accepted 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!


Sign In or Register to comment.