AGE
AGE(birthday, date_format)
Returns the age of someone given their birthday.
| birthday | The birthday of the person. |
| date_format | The date format "UK" or "US". |
REMARKS
* If "birthday" is after todays date, then a negative value is returned.
* If "date_format" is left blank, then "UK" is used.
* The equivalent VBA function is AGE
| | A | | 1 | =_xldudf_JS_ID4_AGE("1 Jul 1977") = #NAME? | | 2 | =_xldudf_JS_ID4_AGE("1/7/1977") = #NAME? | | 3 | =_xldudf_JS_ID4_AGE("1/7/77") = #NAME? | | 4 | =_xldudf_JS_ID4_AGE("1/11/1977") = #NAME? | | 5 | =_xldudf_JS_ID4_AGE("1/11/1977", "UK") = #NAME? | | 6 | =_xldudf_JS_ID4_AGE("1/11/1977", "US") = #NAME? | | 7 | =_xldudf_JS_ID4_AGE("11/1/1977", "UK") = #NAME? | | 8 | =_xldudf_JS_ID4_AGE("11/1/1977", "US") = #NAME? | | 9 | =_xldudf_JS_ID4_AGE("01/02/1920", "UK") = #NAME? | | 10 | =_xldudf_JS_ID4_AGE("15 March 1976", "UK") = #NAME? | | 11 | =_xldudf_JS_ID4_AGE("1 January 2050") = #NAME? | | 12 | =_xldudf_JS_ID4_AGE(1/7.1977) = #NAME? | | 13 | =_xldudf_JS_ID4_AGE(126212) = #NAME? |
|
1 - What is the age of someone who has a birthday on "1/11/1977".
2 - What is the age of someone who has a birthday on "11/1/1977".
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext