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
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Thank you!!

Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!