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!
Help Article Resources
Check out the Formula Handbook template!