Returns the sequential serial number that represents a particular date. If the cell format was General before the function was entered, the result is formatted as a date.
Syntax
DATE(year,month,day)
Year The year argument can be one to four digits. Microsoft Excel interprets the year argument according to the date system you are using. By default, Excel for Windows uses the 1900 date system; Excel for the Macintosh uses the 1904 date system.
For the 1900 date system
· If year is between 0 (zero) and 1899 (inclusive), Excel adds that value to 1900 to calculate the year. For example,
DATE(108,1,2) returns January 2, 2008 (1900+108).
