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) | =DATEVALUE(A1) | =B1 |
| 29 Feb 2012 | =DATEVALUE(A2) | =DATEVALUE(A2) | =B2 |
| April 1, 2012 | =DATEVALUE(A3) | =DATEVALUE(A3) | =B3 |
| 25/12/2012 | =DATEVALUE(A4) | =DATEVALUE(A4) | =B4 |
| 2012-Oct-31 | =DATEVALUE(A5) | =DATEVALUE(A5) | =B5 |
| 5th November | =DATEVALUE(A6) | =DATEVALUE(A6) | =B6 |
| January 1st | =DATEVALUE(A7) | =DATEVALUE(A7) | =B7 |
| April 2012 | =DATEVALUE(A8) | =DATEVALUE(A8) | =B8 |
| 17-03 | =DATEVALUE(A9) | =DATEVALUE(A9) | =B9 |
| 03-2012 | =DATEVALUE(A10) | =DATEVALUE(A10) | =B10 |
| 29 Feb 2011 | =DATEVALUE(A11) | =DATEVALUE(A11) | =B11 |
| 03-05-07 | =DATEVALUE(A12) | =DATEVALUE(A12) | =B12 |
| 03-MAY-07 | =DATEVALUE(A13) | =DATEVALUE(A13) | =B13 |
| 03-13-07 | =DATEVALUE(A14) | =DATEVALUE(A14) | =B14 |