Forum Discussion

trevb's avatar
trevb
Advocate II
10 years ago

Number of Months between two dates

This seems like a really dumb thing to be asking.   I need to count the number of Months between two dates.  I can happily find out the number of days, but that doesn't help much as number of days ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

To have a Decimal number i use:

 

Date.Month([EndDate])-Date.Month([StartDate])
+
((Date.Day([EndDate])/Date.DaysInMonth([EndDate])) + (Duration.TotalDays(Date.EndOfMonth([StartDate])-[StartDate])/Date.DaysInMonth([StartDate]))-1))