How to Calculate Months Difference between Two Dates

Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.

image_anaplan_849.jpg

Accepted answers

emilydunn

After checking with our Customer Success team, I have two options for you:

Depending on the accuracy needed, try: (End Date - Start Date)/30

Month(Date 1) - Month(Date 2)

Will you give one or both a try and let me know know which worked best?
Thanks!
Emily

PrevContributor

Thanks Emily for the fast response.

I ended up using (End Date - Start Date) / 365 * 12. This will give the highest degree of accuracy.

anaplan_2_851.jpg

PrevContributor

Michael - an alternative method is (Year(EndDate)*12 + Month(EndDate)) - (Year(StartDate)*12 + Month(StartDate))

This returns the number of calendar periods and is valid for some calculations.

Best,

Mitch

monthdiff_852.tiff

All comments

emilydunn

After checking with our Customer Success team, I have two options for you:

Depending on the accuracy needed, try: (End Date - Start Date)/30

Month(Date 1) - Month(Date 2)

Will you give one or both a try and let me know know which worked best?
Thanks!
Emily

PrevContributor

Thanks Emily for the fast response.

I ended up using (End Date - Start Date) / 365 * 12. This will give the highest degree of accuracy.

by utilizing the Functions MONTH() and YEAR() you can derive the number of months between 2 date formatted line items with this formula: IF ISBLANK(start date) THEN 0 ELSE IF ISBLANK(end date) THEN YEAR(START()) * 12 + MONTH(START()) - (YEAR(start date) * 12 + MONTH(start date)) ELSE YEAR(end date) * 12 + MONTH(end date) - (YEAR(start date) * 12 + MONTH(start date))

Quick Links

Can you help?

Unanswered questions

Stuck in Activity 2 of L1 exaam
Not able toidentify error. And what is this builtin. Kindly guide
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.