DATE function

The Excel DATE function is a useful tool for working with dates in Excel spreadsheets. It allows you to create a valid date based on the provided year, month, and day values. In simple words, you can use the DATE function to build a date by specifying its components.

Syntax

DATE(year, month, day)

Arguments

yearThe year you want to use in the date. It can be a number, a cell reference, or a formula that returns a year value.
monthThe month you want to use in the date. It can be a number (1-12), a cell reference, or a formula that returns a month value.
dayThe day you want to use in the date. It can be a number (1-31), a cell reference, or a formula that returns a day value.

How to use

Let’s explore how to use the DATE function with a few examples:

This formula will return the date November 2, 2023.

Using invalid date components will result in an error, as there is no February 29 in a non-leap year.

If you have year, month, and day values in cells A1, B1, and C1, respectively, this formula will calculate the date based on those values.

You can also use arithmetic operations within the DATE function. In this case, it will result in the date May 22, 2023.

Additional information

If you’re working with dates in Excel, the DATE function is a valuable tool for creating custom date values. It’s essential to ensure that the provided year, month, and day values are accurate to obtain the desired results. If you encounter errors, check the input values to make sure they represent a valid date.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.