DATE(year,month,day)

Returns the Excel 1900 date system serial number that represents the input year, month, and day. For example, date(2005,2,18) returns 38401 (the 38,401st day since January 1, 1900). Months are numbered 1-12 (January through December). Day is 1-based (1 is the first day of a month).

See also:

DAY

MONTH

WEEKDAY

WEEKNUM

YEAR