DATESERIAL

DATESERIAL(the_date, date_format)
Returns the date serial number given a date in text format.

the_dateThe birthday of the person.
date_formatThe date format "UK" or "US".

REMARKS
* If "dateFormat" is left blank, then "UK" is used.
* If "birthday" is after todays date, then


MORE EXAMPLES

 A
1=JS.DATESERIAL("1/11/1977")
2=JS.DATESERIAL("11/1/1977")
3=JS.DATESERIAL("1/01/2000")
4=JS.DATESERIAL("01/1/2000")
5=JS.DATESERIAL("1 Jan 2000")
6=JS.DATESERIAL("01 January 2000")
7=JS.DATESERIAL("01/13/2000")
8=JS.DATESERIAL("01/13/2000","US")
9=JS.DATESERIAL("01 Seb 2000") invalid date

MORE FUNCTIONS
??


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