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).

Syntax

DATE(year,month,day)

____________________________

See also:

DAY function

MONTH function

WEEKDAY function

WEEKNUM function

YEAR function

Functions

 


Page url: https://www.dplot.com/help/index.htm?date.htm