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)40994
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Mar-26
29 Feb 2012=DATEVALUE(A2)40968
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Feb-29
April 1, 2012=DATEVALUE(A3)41000
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Apr-01
25/12/2012=DATEVALUE(A4)41268
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Dec-25
2012-Oct-31=DATEVALUE(A5)41213
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Oct-31
5th November=DATEVALUE(A6)45966
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Nov-05
January 1st=DATEVALUE(A7)45658
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Jan-01
April 2012=DATEVALUE(A8)41000
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Apr-01
17-03=DATEVALUE(A9)45733
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Mar-17
03-2012=DATEVALUE(A10)40969
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Mar-01
29 Feb 2011=DATEVALUE(A11)40603
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2011-Mar-01
03-05-07=DATEVALUE(A12)37748
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2003-May-07
03-MAY-07=DATEVALUE(A13)39205
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2007-May-03
03-13-07=DATEVALUE(A14)41340
Notice: Trying to access array offset on value of type null in /home/firewirenet/public_html/inventario/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
2013-Mar-07