DATE

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