AGE

Returns the age of someone given their birthday.

birthdayThe birthday of the person.
date_formatThe 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".


alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext