How to calculate the number of months between 2 dates

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Simply, I need a formula to calculate the number of months a vehicle has been in service.  I have a [In Service Date].  So I am thinking something like Today()-[In Service Date]=xxxMonths
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Jeff Mickelsen

Jeff Mickelsen

  • 384 Points 250 badge 2x thumb
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
This worked great!  Thank you!
Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
I would only want to show the whole months.  So if the calculation went into a partial month, I would want it to round up to the next whole number.
Did you get it working based on Mark's formula from the other thread?
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
Yes, it worked perfectly!