DATEVALUE

Converts a date in the form of text to a serial number.


Warning: The PHPExcel DATEVALUE() function accepts a wider range of date formats than MS Excel's DATEFORMAT() function.

Date String Formula Excel DateStamp Formatted DateStamp
26 March 2012=DATEVALUE(A1)409942012-Mar-26
29 Feb 2012=DATEVALUE(A2)409682012-Feb-29
April 1, 2012=DATEVALUE(A3)410002012-Apr-01
25/12/2012=DATEVALUE(A4)412682012-Dec-25
2012-Oct-31=DATEVALUE(A5)412132012-Oct-31
5th November=DATEVALUE(A6)426792016-Nov-05
January 1st=DATEVALUE(A7)423702016-Jan-01
April 2012=DATEVALUE(A8)410002012-Apr-01
17-03=DATEVALUE(A9)424462016-Mar-17
03-2012=DATEVALUE(A10)409692012-Mar-01
29 Feb 2011=DATEVALUE(A11)406032011-Mar-01
03-05-07=DATEVALUE(A12)377482003-May-07
03-MAY-07=DATEVALUE(A13)392052007-May-03
03-13-07=DATEVALUE(A14)413402013-Mar-07