Adding months onto a date

JPFORDTE

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!

JPFORDTE

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!

Genevieve P.

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

JPFORDTE

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!