Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to create a date for January 15, 2024.
Excel
=DATE([1], 1, 15)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the day or month number instead of the year.
Confusing the order of arguments in the DATE function.
✗ Incorrect
The DATE function's first argument is the year. To create January 15, 2024, the year must be 2024.
2fill in blank
mediumComplete the formula to create a date for March 10, 2023.
Excel
=DATE(2023, [1], 10)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the day number instead of the month.
Mixing up the order of arguments.
✗ Incorrect
The second argument in DATE is the month. For March, use 3.
3fill in blank
hardFix the error in the formula to create a date for July 4, 2022.
Excel
=DATE(2022, 7, [1])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the month or year instead of the day.
Entering a day number that is too large for the month.
✗ Incorrect
The third argument in DATE is the day. For July 4, use 4.
4fill in blank
hardFill both blanks to create a date for December 25, 2025.
Excel
=DATE([1], [2], 25)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Swapping the year and month.
Using the wrong month number.
✗ Incorrect
The first argument is the year (2025), and the second is the month (12 for December).
5fill in blank
hardFill all three blanks to create a date for February 29, 2020 (a leap year).
Excel
=DATE([1], [2], [3])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using 28 instead of 29 for the day in a leap year.
Mixing up the order of year, month, and day.
✗ Incorrect
2020 is a leap year, so February (2) has 29 days. The DATE function needs year=2020, month=2, day=29.