Counting Months Formula
EvieSummit
✭✭✭
Hello! I have a counting question I need some assistance with.
I'm trying to count the number of months between two dates (Date Opened and Date Closed). I currently have this formula:
=ROUND(((NETDAYS([Date Opened]@row, [Date Closed]@row) / 365) * 12), 0)
It works beautifully, but we've updated our process from counting in 30 day increments, to counting the number of months involved in the process (e.g. if Date Opened is 12/31/21 and Date Closed is 01/01/2022, it's technically two months).
Is there a formula that can calculate this? I can't find anything online.
Thank you!!
Tags:
Best Answer
-
Hey @EvieSummit
Give this a try:
=MONTH([Close Date]@row) - MONTH([Open Date]@row) + ((YEAR([Close Date]@row) - YEAR([Open Date]@row)) * 12) + 1
Answers
-
Hey @EvieSummit
Give this a try:
=MONTH([Close Date]@row) - MONTH([Open Date]@row) + ((YEAR([Close Date]@row) - YEAR([Open Date]@row)) * 12) + 1
-
It works Devin, thank you so much!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!