DATEVALUE

Date/Time Functions:
Function: DATEVALUE() - Converts a date in the form of text to an Excel serial number.
Warning: The PhpSpreadsheet DATEVALUE() function accepts a wider range of date formats than MS Excel DATEFORMAT() function.
(A1) Date String: 26 March 2012
Formula: =DATEVALUE(A1)
Excel DateStamp: 40994
Formatted DateStamp: 2012-03-26

(A2) Date String: 29 Feb 2012
Formula: =DATEVALUE(A2)
Excel DateStamp: 40968
Formatted DateStamp: 2012-02-29

(A3) Date String: April 1, 2012
Formula: =DATEVALUE(A3)
Excel DateStamp: 41000
Formatted DateStamp: 2012-04-01

(A4) Date String: 25/12/2012
Formula: =DATEVALUE(A4)
Excel DateStamp: 41268
Formatted DateStamp: 2012-12-25

(A5) Date String: 2012-Oct-31
Formula: =DATEVALUE(A5)
Excel DateStamp: 41213
Formatted DateStamp: 2012-10-31

(A6) Date String: 5th November
Formula: =DATEVALUE(A6)
Excel DateStamp: 45966
Formatted DateStamp: 2025-11-05

(A7) Date String: January 1st
Formula: =DATEVALUE(A7)
Excel DateStamp: 45658
Formatted DateStamp: 2025-01-01

(A8) Date String: April 2012
Formula: =DATEVALUE(A8)
Excel DateStamp: 41000
Formatted DateStamp: 2012-04-01

(A9) Date String: 17-03
Formula: =DATEVALUE(A9)
Excel DateStamp: 45733
Formatted DateStamp: 2025-03-17

(A10) Date String: 03-17
Formula: =DATEVALUE(A10)
Excel DateStamp: 45733
Formatted DateStamp: 2025-03-17

(A11) Date String: 03-2012
Formula: =DATEVALUE(A11)
Excel DateStamp: 40969
Formatted DateStamp: 2012-03-01

(A12) Date String: 29 Feb 2011
Formula: =DATEVALUE(A12)
Excel DateStamp: #VALUE!
Formatted DateStamp: #VALUE!

(A13) Date String: 03-05-07
Formula: =DATEVALUE(A13)
Excel DateStamp: 39205
Formatted DateStamp: 2007-05-03

(A14) Date String: 03-MAY-07
Formula: =DATEVALUE(A14)
Excel DateStamp: 39205
Formatted DateStamp: 2007-05-03

(A15) Date String: 03-13-07
Formula: =DATEVALUE(A15)
Excel DateStamp: 41340
Formatted DateStamp: 2013-03-07

(A16) Date String: 13-03-07
Formula: =DATEVALUE(A16)
Excel DateStamp: 39154
Formatted DateStamp: 2007-03-13

(A17) Date String: 03/13/07
Formula: =DATEVALUE(A17)
Excel DateStamp: 41340
Formatted DateStamp: 2013-03-07

(A18) Date String: 13/03/07
Formula: =DATEVALUE(A18)
Excel DateStamp: 39154
Formatted DateStamp: 2007-03-13