Recall & Review
beginner
What does the DATE function do in Excel?
The DATE function creates a date value from separate year, month, and day numbers. It combines these parts into a valid date Excel can understand.
Click to reveal answer
beginner
How do you write the DATE function syntax?
The syntax is
=DATE(year, month, day). You put the year, month, and day numbers inside the parentheses, separated by commas.Click to reveal answer
intermediate
What happens if you use a month number greater than 12 in the DATE function?
Excel adds the extra months to the year. For example,
=DATE(2024, 14, 5) means 14 months after January 2024, so it becomes February 5, 2025.Click to reveal answer
intermediate
Can the DATE function handle day numbers larger than the days in a month?
Yes. If the day number is too big, Excel adds the extra days to the next month. For example,
=DATE(2024, 1, 35) becomes February 4, 2024.Click to reveal answer
beginner
Why use the DATE function instead of typing a date directly?
Using DATE helps avoid errors with date formats and makes formulas clearer. It also lets you build dates dynamically from numbers in other cells.
Click to reveal answer
What is the correct way to create January 15, 2024 using the DATE function?
✗ Incorrect
The DATE function uses the order year, month, day. So =DATE(2024, 1, 15) is correct.
What date does =DATE(2023, 13, 1) represent?
✗ Incorrect
Month 13 means 1 month after December 2023, so it becomes January 1, 2024.
If you enter =DATE(2024, 2, 30), what will Excel show?
✗ Incorrect
February 30 is 2 days after February 28 (or 29 in leap years). Excel adds days to March 1, 2024.
Why might you use the DATE function instead of typing a date directly?
✗ Incorrect
All these reasons make the DATE function useful for creating dates reliably.
What will =DATE(2024, 0, 15) return?
✗ Incorrect
Month 0 means one month before January 2024, so it becomes December 15, 2023.
Explain how the DATE function works and why it is useful in Excel.
Think about how you can build a date from separate numbers.
You got /5 concepts.
Describe what happens if you use a month or day number outside the normal range in the DATE function.
Imagine counting months or days beyond the calendar limits.
You got /4 concepts.