Getting correct number of months between a date and today

Hello, I'm trying to work with a formula to find the number of months between a static date and today for a PTO sheet (see attached). I thought I had the formula worked out, but can't get it to seem to work..




Best Answer

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

    Try this (you'll need decimals)

    =(NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12

    Or, if you only want the integer...

    =ROUND((NETDAYS([Date Submitted]@row, TODAY()) / 365) * 12)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!