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

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

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

Thank you!!

Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!