AGE

AGE(birthday, date_format)
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 a negative value is returned.
* If "date_format" is left blank, then "UK" is used.
* If "dtBirthday" is not a valid date , then #VALUE! is returned.


MORE EXAMPLES

 A
1=JS.AGE("1 Jul 1977") = 48
2=JS.AGE("1/7/1977") = 48
3=JS.AGE("1/7/77") = 0
4=JS.AGE("1/11/1977") = 48
5=JS.AGE("1/11/1977", "UK") = 48
6=JS.AGE("1/11/1977", "US") = 49
7=JS.AGE("11/1/1977", "UK") = 49
8=JS.AGE("11/1/1977", "US") = 48
9=JS.AGE("01/02/1920", "UK") = 106
10=JS.AGE("15 March 1976", "UK") = 50
11=JS.AGE("1 January 2050") = -24
12=JS.AGE(1/7.1977) = 126
13=JS.AGE(126212) = -220

MORE FUNCTIONS
??


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