# Discussions

View Only

## How to calculate the number of months between 2 dates

• #### 1.  How to calculate the number of months between 2 dates

Posted 04-16-2019 14:57
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

• #### 2.  RE: How to calculate the number of months between 2 dates

Posted 04-16-2019 16:52

• #### 3.  RE: How to calculate the number of months between 2 dates

Posted 04-16-2019 18:46
This worked great!  Thank you!

• #### 4.  RE: How to calculate the number of months between 2 dates

Bronze
Contributor
Posted 04-16-2019 17:05
Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?

• #### 5.  RE: How to calculate the number of months between 2 dates

Posted 04-16-2019 18:47
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.

• #### 6.  RE: How to calculate the number of months between 2 dates

Bronze
Contributor
Posted 04-16-2019 19:25
Did you get it working based on Mark's formula from the other thread?

• #### 7.  RE: How to calculate the number of months between 2 dates

Posted 04-18-2019 13:03
Yes, it worked perfectly!