DATE

Constructs a date from the specified year, month and day of the month.

Syntax

DATE( Integer year, Integer month, Integer day ) → Date

Parameters

year

Required. The value of the year argument.

month

Required. An integer representing the month of the year from 1 to 12 (January to December).

day

Required. An integer specifying the day of the month from 1 to 31.

Remarks

This method computes the date's serial number given a year, a month, and a day of the Gregorian calendar. Fractional values are automatically truncated. If month is greater than 12 and day is greater than the days of month, the resulting date will be computed by rolling over to the next month or year as necessary. If month or day are negative, their magnitude is subtracted from the first month of the specified year or the first day of the specified month.

If the result is displayed in a cell with Format set to General, the value will be formatted as a date. To see the value as a serial number, set the format of the cell to one of the numeric formats.

Example

Formula

=DATE(2013,1,1)
=DATE(YEAR(TODAY()),1,10)

See Also

Function Reference
TIME Function