Forum Discussion

HemaRajendran1's avatar
HemaRajendran1
Qrew Trainee
3 years ago

How to calculate the number of months between two dates?

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

1 Reply

  • AustinK's avatar
    AustinK
    Qrew Commander
    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)