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) | =DATE(A1,B1,C1) | =D1 |
| 2012 | 2 | 29 | =DATE(A2,B2,C2) | =DATE(A2,B2,C2) | =D2 |
| 2012 | 4 | 1 | =DATE(A3,B3,C3) | =DATE(A3,B3,C3) | =D3 |
| 2012 | 12 | 25 | =DATE(A4,B4,C4) | =DATE(A4,B4,C4) | =D4 |
| 2012 | 10 | 31 | =DATE(A5,B5,C5) | =DATE(A5,B5,C5) | =D5 |
| 2012 | 11 | 5 | =DATE(A6,B6,C6) | =DATE(A6,B6,C6) | =D6 |
| 2012 | 1 | 1 | =DATE(A7,B7,C7) | =DATE(A7,B7,C7) | =D7 |
| 2012 | 3 | 17 | =DATE(A8,B8,C8) | =DATE(A8,B8,C8) | =D8 |
| 2011 | 2 | 29 | =DATE(A9,B9,C9) | =DATE(A9,B9,C9) | =D9 |
| 7 | 5 | 3 | =DATE(A10,B10,C10) | =DATE(A10,B10,C10) | =D10 |
| 2012 | 13 | 1 | =DATE(A11,B11,C11) | =DATE(A11,B11,C11) | =D11 |
| 2012 | 11 | 45 | =DATE(A12,B12,C12) | =DATE(A12,B12,C12) | =D12 |
| 2012 | 0 | 0 | =DATE(A13,B13,C13) | =DATE(A13,B13,C13) | =D13 |
| 2012 | 1 | 0 | =DATE(A14,B14,C14) | =DATE(A14,B14,C14) | =D14 |
| 2012 | 0 | 1 | =DATE(A15,B15,C15) | =DATE(A15,B15,C15) | =D15 |
| 2012 | -2 | 2 | =DATE(A16,B16,C16) | =DATE(A16,B16,C16) | =D16 |
| 2012 | 2 | -2 | =DATE(A17,B17,C17) | =DATE(A17,B17,C17) | =D17 |
| 2012 | -2 | -2 | =DATE(A18,B18,C18) | =DATE(A18,B18,C18) | =D18 |