The DATE function with example in Excel

The DATE function in Excel is used to create a date based on the provided year, month, and day. Its syntax is:

excel
DATE(year, month, day)

• year: The year for the date.
• month: The month for the date (a number between 1 and 12).
• day: The day of the month for the date (a number between 1 and 31).

Here's an example of how you can use the DATE function:

Suppose you want to create a date for May 26, 2024:

excel
=DATE(2024, 5, 26)

This formula will return the date May 26, 2024.

You can also use cell references or other formulas to provide the year, month, and day values dynamically. For instance:

excel
=DATE(A1, B1, C1)

Here, A1, B1, and C1 might contain the year, month, and day values respectively.