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
| year | The year you want to use in the date. It can be a number, a cell reference, or a formula that returns a year value. |
| month | The 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. |
| day | The 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:
|
1 |
=DATE(2023, 11, 2) |
This formula will return the date November 2, 2023.
|
1 |
=DATE(2023, 2, 29) |
Using invalid date components will result in an error, as there is no February 29 in a non-leap year.
|
1 |
=DATE(A1, B1, C1) |
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.
|
1 |
=DATE(2023, 5, 15+7) |
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.