Calculating the number of months between 2 dates over multiple years

Maxine Roberts
✭✭✭✭
Best Answer
-
You could use something along the lines of
=((12 - MONTH([Go Live Date]@row)) + MONTH(TODAY())) + (((YEAR(TODAY()) - 1) - YEAR([Go Live Date]@row)) * 12)
Answers
-
You could use something along the lines of
=((12 - MONTH([Go Live Date]@row)) + MONTH(TODAY())) + (((YEAR(TODAY()) - 1) - YEAR([Go Live Date]@row)) * 12)
-
Thank you Paul that appears to be working fine!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!