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
* If "date_format" is left blank, then "UK" is used.
* The equivalent VBA function is AGE
| | A | | 1 | =JS.AGE("1 Jul 1977") | | 2 | =JS.AGE("1/7/1977") | | 3 | =JS.AGE("1/7/77") | | 4 | =JS.AGE("1/11/1977") | | 5 | =JS.AGE("1/11/1977","UK") | | 6 | =JS.AGE("1/11/1977","US") | | 7 | =JS.AGE("11/1/1977","UK") | | 8 | =JS.AGE("11/1/1977","US") | | 9 | =JS.AGE("01/02/1920","UK") | | 10 | =JS.AGE("15 March 1976","UK") | | 11 | =JS.AGE(1/7.1977) | | 12 | =JS.AGE(126212) |
|
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".
