DATE

See also A-Z Spreadsheet Function List

Description Returns the serial number of the supplied date.

Syntax DATE(year, month, day)

year is 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 is a number representing the month (e.g., 12 represents December). If a number greater than 12 is supplied, the number is added to the to the first month of the specified year.

day is 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.

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

Examples DATE(94, 6, 21) returns 34506

         DATE(99, 3, 6) returns 36225