User Tools

Site Tools


syntax:functions:age

Age(date1, date2)

Category: Date and Time function


Description

This function returns the number of full years between two dates (date1 and date2).


Arguments

ArgumentTypeDescription
date1Date or Number (date serial)An expression representing a date. The date value to calculate the difference from.
date2Date or Number (date serial)An expression representing a date. The date value to calculate the difference to.

Return value type: Number (Integer).


Remarks

The result is a non-fractional number (integer), as an absolute value, so the dates can be entered in either order.

The date1 and date2 arguments can take any value or expression that evaluates to a date serial value. Examples include:

  • A date string: #2019-12-12
  • A date serial value: 43811 (the date serial for "2019-12-12")
  • A date value created using any of the Date/Time functions that returns a date serial value.


Examples

age(#1960-05-10, #2021-08-29)  //Returns 61.
age(#2021-08-29, #1960-05-10)  //Returns 61.  (Dates are in reversed order from above.)
age(#1825-06-15, #2050-06-15)  //Returns 225.


See also

syntax/functions/age.txt · Last modified: 2021/08/30 01:55 by craigt