AGE

Returns the age of someone given their birthday.

birthdayThe birthday of the person.
dateFormatThe date format "UK" or "US".

Remarks

* If "dateFormat" is left blank, then "UK" is used.
* If "birthday" is after todays date, then
*) The equivalent VBA function is AGE

 A
1=JS.AGE("1/11/1977") = 0
2=JS.AGE("1/11/1977","UK") = 0
3=JS.AGE("1/11/1977","US") = 0
4=JS.AGE("11/1/1977","UK") = 0
5=JS.AGE("11/1/1977","US") = 0
6=JS.AGE("01/02/1920","UK") = 0
7=JS.AGE("15 March 1976","UK") = 0
8fn - AGE2(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".
3 - ??


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