DATE

Date/Time Functions:
Function: DATE() - Returns the Excel serial number of a particular date.
(A1) Year: 2012
(B1) Month: 3
(C1) Day: 26
Formula: =DATE(A1,B1,C1)
Excel DateStamp: 40994
Formatted DateStamp: 2012-03-26

(A2) Year: 2012
(B2) Month: 2
(C2) Day: 29
Formula: =DATE(A2,B2,C2)
Excel DateStamp: 40968
Formatted DateStamp: 2012-02-29

(A3) Year: 2012
(B3) Month: 4
(C3) Day: 1
Formula: =DATE(A3,B3,C3)
Excel DateStamp: 41000
Formatted DateStamp: 2012-04-01

(A4) Year: 2012
(B4) Month: 12
(C4) Day: 25
Formula: =DATE(A4,B4,C4)
Excel DateStamp: 41268
Formatted DateStamp: 2012-12-25

(A5) Year: 2012
(B5) Month: 10
(C5) Day: 31
Formula: =DATE(A5,B5,C5)
Excel DateStamp: 41213
Formatted DateStamp: 2012-10-31

(A6) Year: 2012
(B6) Month: 11
(C6) Day: 5
Formula: =DATE(A6,B6,C6)
Excel DateStamp: 41218
Formatted DateStamp: 2012-11-05

(A7) Year: 2012
(B7) Month: 1
(C7) Day: 1
Formula: =DATE(A7,B7,C7)
Excel DateStamp: 40909
Formatted DateStamp: 2012-01-01

(A8) Year: 2012
(B8) Month: 3
(C8) Day: 17
Formula: =DATE(A8,B8,C8)
Excel DateStamp: 40985
Formatted DateStamp: 2012-03-17

(A9) Year: 2011
(B9) Month: 2
(C9) Day: 29
Formula: =DATE(A9,B9,C9)
Excel DateStamp: 40603
Formatted DateStamp: 2011-03-01

(A10) Year: 7
(B10) Month: 5
(C10) Day: 3
Formula: =DATE(A10,B10,C10)
Excel DateStamp: 2680
Formatted DateStamp: 1907-05-03

(A11) Year: 2012
(B11) Month: 13
(C11) Day: 1
Formula: =DATE(A11,B11,C11)
Excel DateStamp: 41275
Formatted DateStamp: 2013-01-01

(A12) Year: 2012
(B12) Month: 11
(C12) Day: 45
Formula: =DATE(A12,B12,C12)
Excel DateStamp: 41258
Formatted DateStamp: 2012-12-15

(A13) Year: 2012
(B13) Month: 0
(C13) Day: 0
Formula: =DATE(A13,B13,C13)
Excel DateStamp: 40877
Formatted DateStamp: 2011-11-30

(A14) Year: 2012
(B14) Month: 1
(C14) Day: 0
Formula: =DATE(A14,B14,C14)
Excel DateStamp: 40908
Formatted DateStamp: 2011-12-31

(A15) Year: 2012
(B15) Month: 0
(C15) Day: 1
Formula: =DATE(A15,B15,C15)
Excel DateStamp: 40878
Formatted DateStamp: 2011-12-01

(A16) Year: 2012
(B16) Month: -2
(C16) Day: 2
Formula: =DATE(A16,B16,C16)
Excel DateStamp: 40818
Formatted DateStamp: 2011-10-02

(A17) Year: 2012
(B17) Month: 2
(C17) Day: -2
Formula: =DATE(A17,B17,C17)
Excel DateStamp: 40937
Formatted DateStamp: 2012-01-29

(A18) Year: 2012
(B18) Month: -2
(C18) Day: -2
Formula: =DATE(A18,B18,C18)
Excel DateStamp: 40814
Formatted DateStamp: 2011-09-28