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

Options

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!


Answers

  • SueinSpain
    SueinSpain ✭✭✭✭✭
    Options

    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

    Sue Rogers

    AmerisourceBergen - MWI Animal Health

    Business Analyst

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!