This function returns the serial date value for a particular date, specified by the year, month, and day.
DATE(year,month,day)
This function has these arguments:
| Argument | Description |
|---|---|
| year | Number representing the year, from 1 to 9999, using four digits; if not integer, number is truncated |
| month | Number representing the month of the year; if not integer, number is truncated |
| day | Number representing the day of the month; if not integer, number is truncated |
If month is greater than 12, then month increments by the number of months over 12 and the year advances, if needed. For example, DATE(2003,16,2) returns the serial number 38079 representing April 2, 2004.
If day is greater than the number of days in the specified month, then day increments the number of days from the first day of the next month. For example, DATE(2004,1,35) returns the serial number 38021 representing February 4, 2004.
If values for the arguments are not integers, any decimal places are truncated. Negative values for months are taken from the year into previous years. Negative values for days are taken from the month into previous months.
Accepts numeric data. Returns the serial number of the date.
DATE(A1,B1,C1)
DATE(R1C1,R1C2,R1C3)
DATE(2019,1,1) gives the result 43466 which can be formatted as 01-01-2019
DATE(2019,2,13) gives the result 43509 which can be formatted as 13-02-2019
This function is available in product version 1.0 or later.
DATEVALUE | TIME | Date and Time Functions