Discussions

Expand all | Collapse all

How to calculate the number of months between two dates?

  • 1.  How to calculate the number of months between two dates?

    Posted 18 days ago
    Hi Folks, I'm trying to calculate the number of months between two dates.
    Ex: [Close date]-[Start date]=No of months(difference)

    Thanks in Advance

    ------------------------------
    Hema Rajendran
    ------------------------------


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

    Posted 18 days ago
    There is not really a great way to do this. The way I have seen posted about that works but is not perfect is to just divide your results by 30 days. It will not be an exactly right but it will be very close. The more months this formula calculates the more incorrect it will be. If you need to calculate months for a year or less I think it is a good solution.

    This needs to be a formula numeric field. If you test this by September 1st 2020 - September 1st 2021 you get -12.16 for the months as 12 months have passed. You could probably clean up the number as well and not use decimals.

    ([date 1] - [date 2]) / days(30)