Question

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

emilydunn · Accepted Answer

After checking with our Customer Success team, I have two options for you:* Depending on the accuracy needed, try: (End Date - Start Date)/30

OR* 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 · Accepted Answer

Thanks Emily for the fast response.

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

PrevContributor · Accepted Answer

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