Number of month between dates

A

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
 
A

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.
 
Top