DATE


Description Returns the serial number of the supplied date.

Syntax DATE ( year, month, day )

Argument Description
year A number from 1900 to 2078. If year is between 1920 to 2019, you can specify two digits to represent the year; otherwise specify all four digits.
month A number representing the month (for example, 12 represents December). If a number greater than 12 is supplied, the number is added to the first month of the specified year.
day A number representing the day of the month. If the number you specify for day exceeds the number of days in that month, the number is added to the first day of the specified month.

Examples This function returns 34506:

DATE(94, 6, 21)

This function returns 36225:

DATE(99, 3, 6)

See Also DATEVALUE, DAY, MONTH, NOW, TIMEVALUE, TODAY, YEAR