Calculates the difference between two date values in years and months.
Syntax:
AGE( recent_date, earlier_date )
recent_date should be the more recent date and earlier_date the earlier date.
This function returns the difference between two date values in years and months as a floating point number.
Use INT()
to extract the years part of the result.
Use result-INT(result)
to extract the months part of the result.
Example:
AGE(26.6.1994, 25.8.1982)
returns the age of someone aged 12 years and 10 months as the number 12.10
.