DATESERIAL

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
* The equivalent VBA function is DATESERIAL

 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

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".


microsoft excel docs

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