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) |