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.

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!