The DATE function in Excel is used to create a date by specifying the year, month, and day. It is helpful when you need to work with dates in Excel and want to construct a date value from individual components.


=DATE(year, month, day)

year The year component of the date.
month The month component of the date.
day The day component of the date.

About DATE

When you find yourself in situations where you need to piece together a specific date in Excel, that's where the DATE function comes into play. It simplifies the process of creating a date value by allowing you to input the individual elements that comprise a date: the year, the month, and the day. This way, you can easily construct a date with precise details tailored to your needs to perform various calculations or formatting tasks involving dates.


To create the date June 15, 2022, you can use the DATE function as follows: =DATE(2022, 6, 15)

If you want to determine the date 90 days after a certain date, you can use the DATE function in combination with other functions like DAY, MONTH, and YEAR for calculations.


How does the DATE function work in Excel?

The DATE function in Excel constructs a date based on the year, month, and day components provided as arguments. It returns a serial number representing the specified date, which can then be formatted as a date in Excel.

Can the DATE function handle dates before the year 1900 or after the year 9999?

Yes, the DATE function in Excel can handle dates ranging from January 1, 1900, to December 31, 9999. Dates outside of this range are not supported by Excel's DATE function.

What happens if invalid values are provided to the DATE function?

If invalid values are provided to the DATE function, such as a month greater than 12 or a day greater than the maximum number of days in the specified month, Excel will return a #VALUE! error.

Related functions