====== Age(date1, date2) ====== Category: Date and Time function \\ =====Description===== This function returns the number of full years between two dates (//date1// and //date2//). \\ =====Arguments===== ^Argument^Type^Description^ |date1|Date or Number (date serial)|An expression representing a date. The date value to calculate the difference from.| |date2|Date 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:agemonths|AgeMonths(date1,date2)]]