Counting Months Formula
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!