Navigation:  Reference > Functions >

DATE function

Print this Topic Previous pageReturn to chapter overviewNext page

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 function

MONTH function

WEEKDAY function

WEEKNUM function

YEAR function



Page url: