Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to create a date for January 1, 2023.
Google Sheets
=DATE([1], 1, 1)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the month number instead of the year.
Using a two-digit year like 23 instead of 2023.
✗ Incorrect
The DATE function needs the year as the first argument. Here, 2023 is the correct year.
2fill in blank
mediumComplete the formula to create a date for March 15, 2024.
Google Sheets
=DATE(2024, [1], 15)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the day number instead of the month.
Confusing month numbers with day numbers.
✗ Incorrect
The second argument in DATE is the month. March is month 3.
3fill in blank
hardFix the error in the formula to create a date for July 4, 2022.
Google Sheets
=DATE(2022, 7, [1])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the month number instead of the day.
Using the year or month number in the day position.
✗ Incorrect
The third argument in DATE is the day. July 4 means day 4.
4fill in blank
hardFill both blanks to create a date for December 25, 2025.
Google Sheets
=DATE([1], [2], 25)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Swapping year and month numbers.
Using 11 instead of 12 for December.
✗ Incorrect
The first blank is the year 2025, and the second blank is the month December (12).
5fill in blank
hardFill all three blanks to create a date for February 29, 2020 (leap year).
Google Sheets
=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.
Using a non-leap year like 2019.
✗ Incorrect
2020 is the leap year, 2 is February, and 29 is the day for leap day.