AGE

Calculates the difference between two date values in years and months.

Syntax:

AGE(recent:date, earlier:date)

recent should be the more recent date and earlier 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.