Warning: The PhpSpreadsheet 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 | 2012-Mar-26 |
| 29 Feb 2012 | =DATEVALUE(A2) | 40968 | 2012-Feb-29 |
| April 1, 2012 | =DATEVALUE(A3) | 41000 | 2012-Apr-01 |
| 25/12/2012 | =DATEVALUE(A4) | 41268 | 2012-Dec-25 |
| 2012-Oct-31 | =DATEVALUE(A5) | 41213 | 2012-Oct-31 |
| 5th November | =DATEVALUE(A6) | 45601 | 2024-Nov-05 |
| January 1st | =DATEVALUE(A7) | 45292 | 2024-Jan-01 |
| April 2012 | =DATEVALUE(A8) | 41000 | 2012-Apr-01 |
| 17-03 | =DATEVALUE(A9) | 45368 | 2024-Mar-17 |
| 03-2012 | =DATEVALUE(A10) | 40969 | 2012-Mar-01 |
| 29 Feb 2011 | =DATEVALUE(A11) | #VALUE! | #VALUE! |
| 03-05-07 | =DATEVALUE(A12) | 39205 | 2007-May-03 |
| 03-MAY-07 | =DATEVALUE(A13) | 39205 | 2007-May-03 |
| 03-13-07 | =DATEVALUE(A14) | 41340 | 2013-Mar-07 |