How to Calculate End Date by Adding the Total Months to Start Date

Jem Victoria De los Reyes

Hi All,

I need help on how to automatically calculate the due date by adding the columns "Last Maintained Date" with the "Interval (months)" column. I hope to hear from you soon. Thank you!

SueinSpain

In the Formula workbook, advanced formula there is an example of how to do this.

It is complex as the need for rolling over the years when adding months but here is the example I clipped

Where Date@row = your [Last Maintained Date]@row

and + Months@row = your [Interval(months)]@row

HI think it would look like this.....

=DATE(YEAR([Last Maintained Date]@row) + ROUNDDOWN((MONTH([Last Maintained Date]@row) + [Interval (months)]@row - 1) / 12), IF(MOD(MONTH([Last Maintained Date]@row) + [Interval (months)]@row, 12) = 0, 12, MOD(MONTH([Last Maintained Date]@row) + [Interval (months)]@row, 12)), DAY([Last Maintained Date]@row))

Hope this helps

Sue