MS Excel: Date Function
In Excel, the Date function returns the serial number of a date.
The syntax for the Date function is:
Date( year, month, day )
year is a number that is between one and four digits.
- If the year is between 0 and 1899, the year value is added to 1900 to determine the year.
- If the year is between 1900 and 9999, the Date function uses the year value as the year.
- If the year is greater than 9999, the Date function will return the #NUM! error.
month is a number representing the month value. If the month value is greater than 12, the Date function adds that number of months to the first month of the year specified in the year parameter.
day is a number representing the day value. If the day value is greater than the number of days in the month specified, the Date function add that number of days to the first day in the month specified in the month parameter.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Date(2003,11,30) would return 'Nov 30, 2003' =Date(2003,11,31) would return 'Dec 1, 2003 =Date(A1, A2, A3) would return 'Nov 30, 2003'