DATEDIF

[WayneLambert]

DATEDIF is a useful formula to determine the number of years, months, days, or any combination thereof, between two dates:

=DATEDIF([Start Date],[End Date],"y") will return the number of complete years

=DATEDIF([Start Date],[End Date],"m") will return the number of complete months

=DATEDIF([Start Date],[End Date],"d") will return the number of complete days

y and m can be used together just to return the number of remaining months (like you could with the MOD function). For example:

=DATEDIF([Start Date],[End Date],"y")&" years "&DATEDIF([Start Date],[End Date],"ym")&" months"

The formula above returns y years and m months, where m is the modulo (MOD) number of months remaining once the divisor of 12 (for m months per year) is used.