Count the Number of Whole Years between Two Dates

To count the number of years between two dates, you use the Year Difference function.

The Year Difference function returns the number of whole years between two dates. This calculation includes only one endpoint.

For example:

the person's age = YearDifference(the person's date of birth, the current date)

If the person's date of birth is 31/10/1910 and the current date is 26/06/2009, the person's age is 98.

Note: The order of the two dates in the function does not affect the result.