DATE
Returns the serial number of a particular date.
| Date Value |
Formula |
Excel DateStamp |
Formatted DateStamp |
| Year |
Month |
Day |
| 2012 | 3 | 26 | =DATE(A1,B1,C1) | 40994 | 2012-Mar-26 |
| 2012 | 2 | 29 | =DATE(A2,B2,C2) | 40968 | 2012-Feb-29 |
| 2012 | 4 | 1 | =DATE(A3,B3,C3) | 41000 | 2012-Apr-01 |
| 2012 | 12 | 25 | =DATE(A4,B4,C4) | 41268 | 2012-Dec-25 |
| 2012 | 10 | 31 | =DATE(A5,B5,C5) | 41213 | 2012-Oct-31 |
| 2012 | 11 | 5 | =DATE(A6,B6,C6) | 41218 | 2012-Nov-05 |
| 2012 | 1 | 1 | =DATE(A7,B7,C7) | 40909 | 2012-Jan-01 |
| 2012 | 3 | 17 | =DATE(A8,B8,C8) | 40985 | 2012-Mar-17 |
| 2011 | 2 | 29 | =DATE(A9,B9,C9) | 40603 | 2011-Mar-01 |
| 7 | 5 | 3 | =DATE(A10,B10,C10) | 2680 | 1907-May-03 |
| 2012 | 13 | 1 | =DATE(A11,B11,C11) | 41275 | 2013-Jan-01 |
| 2012 | 11 | 45 | =DATE(A12,B12,C12) | 41258 | 2012-Dec-15 |
| 2012 | 0 | 0 | =DATE(A13,B13,C13) | 40877 | 2011-Nov-30 |
| 2012 | 1 | 0 | =DATE(A14,B14,C14) | 40908 | 2011-Dec-31 |
| 2012 | 0 | 1 | =DATE(A15,B15,C15) | 40878 | 2011-Dec-01 |
| 2012 | -2 | 2 | =DATE(A16,B16,C16) | 40818 | 2011-Oct-02 |
| 2012 | 2 | -2 | =DATE(A17,B17,C17) | 40937 | 2012-Jan-29 |
| 2012 | -2 | -2 | =DATE(A18,B18,C18) | 40814 | 2011-Sep-28 |