Returns the difference between two dates in years and months as a floating point number.
Syntax:
AGE(recent:date, earlier:date)
recent should be the more recent date and earlier the earlier date.
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
.