Number of month between dates

[alecgreen]

Hi

I need to calculate the number of months from a given date (say
01/01/2010) and todays date. Any ideas please


Thanks

Alec

 

[Allen Browne]

See help (in the code window) on the DateDif() function.

Example:
=DateDiff("m", #1/1/2020#, Date())

Note that this measures calendar months, ignoring the days of the month.