=DATE(2001, 15, 2) returns March 2, 2002, because March 2002 is 15 months after the first month of 2001. : DATE « Date Time functions « Microsoft Office Excel 2007 Tutorial

Home
Microsoft Office Excel 2007 Tutorial
1.Introduction
2.Editing
3.Format Style
4.Table
5.Chart
6.Formula
7.Workbook Worksheet
8.Wordart Clip Art Shape Picture
9.PivotTable PivotChart
10.Data Analysis
11.Macro ActiveX Add in
12.Security
13.Collaboration
14.Database functions
15.Date Time functions
16.Engineering functions
17.Information functions
18.Logical functions
19.Lookup Reference functions
20.Math Trigonometry functions
21.Statistical functions
22.Text functions
Microsoft Office Excel 2007 Tutorial » Date Time functions » DATE 




Input the formula: =DATE(2001152)
Input the formula: =DATE(2001, 15, 2)














15.1.DATE
15.1.1.DATE(year,month,day) returns a particular dateDATE(year,month,day) returns a particular date
15.1.2.=DATE(2006, -5, 16) returns the date July 16, 2005 because July 2005 is 5 months before the first month of 2006.=DATE(2006, -5, 16) returns the date July 16, 2005 because July 2005 is 5 months before the first month of 2006.
15.1.3.=DATE(2001, 15, 2) returns March 2, 2002, because March 2002 is 15 months after the first month of 2001.=DATE(2001, 15, 2) returns March 2, 2002, because March 2002 is 15 months after the first month of 2001.
15.1.4.=DATE(2003, 2, 30) returns March 2, 2003, because February does not have 30 days.=DATE(2003, 2, 30) returns March 2, 2003, because February does not have 30 days.
15.1.5.To generate a series of dates separated by seven daysTo generate a series of dates separated by seven days
15.1.6.Generate a series of dates separated by one month
15.1.7.To generate a series of dates separated by one year
15.1.8.Import data that contains dates coded as text strings
15.1.9.Expresses the date in cell A1 as an ordinal date:Expresses the date in cell A1 as an ordinal date:
15.1.10.To enter New Year's Day for a specific year in cell A1To enter New Year's Day for a specific year in cell A1
15.1.11.INDEPENDENCE DAY always falls on July 4:INDEPENDENCE DAY always falls on July 4:
15.1.12.VETERANS DAY always falls on November 11:VETERANS DAY always falls on November 11:
15.1.13.CHRISTMAS DAY always falls on December 25:CHRISTMAS DAY always falls on December 25:
15.1.14.Calculating the Number of Days between Two DatesCalculating the Number of Days between Two Dates
15.1.15.Return the date for Independence Day (July 4th) of the current year:
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.