How do I convert this to the number of months instead of days?


How do I convert this number of days calculated between to dates into months?

=NETDAYS([Contract Effective Date]@row, [Contract Expiration Date]@row)

Best Answer

  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭
    Answer ✓

    Hello @jcepon,

    You could use:

    =VALUE(YEAR([Contract Expiration Date]@row) + RIGHT("00" + MONTH([Contract Expiration Date]@row); 2)) - VALUE(YEAR([Contract Effective Date]@row) + RIGHT("00" + MONTH([Contract Effective Date]@row); 2))

    However: be aware for the transition of years: for example the diff between dec-21 and jan-22 is of course 89 and not 1 with this formula. Of course the formula must be modified taken into account the transition of years, something with MOD(....;12) when Years differ. If anyone has an idea ???


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!