# Discussions

View Only

## How to calculate the number of months between two dates? #### Hema Rajendran18 days ago • #### 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)

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