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