How to calculate the number of months between 2 dates
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
Forum Discussion
Do you need the answer in whole months? Rounded up or down? Or fractional months? Or months + days?
- 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?
- Yes, it worked perfectly!
