Ways to see total duration in months

I'm looking for a way to see the total duration of a project in months.

I've found the NETDAYS formula, but the unit is days, not months.

Is there a way around this?

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 11/04/21 Answer ✓

    Hi @rossbollinger

    What about taking the total days between the two then dividing by 30?

    =([End Date]@row - [Start Date]@row) / 30

    You can use the ROUND function to round the number.

    =ROUND(([End Date]@row - [Start Date]@row) / 30)

    In this instance I'm rounding UP, so instead of 6 months it says 7 as it's closer to 7, but you could Round Down as well.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!