Function :DATE()

📘 Definition:

The DATE function in Excel is used to create a valid date by combining year, month, and day numbers.
It’s especially useful when you have these values in different cells and need to make a single date.

=DATE(year, month, day)

• year → The year number (like 2025)

• month → The month number (1–12)

• day → The day number (1–31)

Example-1

Step-by-Step Explanation:

1. A2 = 2025, B2 = 1, C2 = 26

2. Excel joins them using =DATE(2025,1,26)

3. The output is 26-Jan-2025

4. You can change the format to “Long Date” → “Sunday, 26 January 2025” if needed.

Example 2:

If you enter: =DATE(2025,13,15)

Excel will automatically convert 13th month → Next year, January,
so result = 15-Jan-2026.

Why It’s Useful:

• Creating dates from separate year, month, and day columns.

• Combining text-based data into valid Excel dates.

• Avoiding date errors caused by regional formats (like DD/MM/YYYY).

Example 2:

If you enter:

=DATE(2025,13,15)

Excel will automatically convert 13th month → Next year, January,
so result = 15-Jan-2026.

Why It’s Useful:

• Creating dates from separate year, month, and day columns.

• Combining text-based data into valid Excel dates.

• Avoiding date errors caused by regional formats (like DD/MM/YYYY).

Project Task 1: Create Employee Joining Dates

Table:

👉 Task: Use the DATE() function to fill the Joining Date column.
Then format the date as DD-MMM-YYYY.

Project Task 2: Generate Student Admission Dates Automatically

Table:

👉 Task:

1. Create Admission Dates using DATE()

2. Format them as “Long Date”

3. Calculate how many students joined in 2025 (using YEAR() with COUNTIF later).