Discussions

Expand all | Collapse all

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



  • 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!