DATE function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete 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'

A2022

B1

C2023

D12

Attempts:

3 left

💡 Hint

Common Mistakes

Using the month number instead of the year.

Using a two-digit year like 23 instead of 2023.

The DATE function needs the year as the first argument. Here, 2023 is the correct year.

2fill in blank

medium

Complete 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'

A1

B5

C12

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using the day number instead of the month.

Confusing month numbers with day numbers.

The second argument in DATE is the month. March is month 3.

3fill in blank

hard

Fix 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'

A4

B7

C14

D22

Attempts:

3 left

💡 Hint

Common Mistakes

Using the month number instead of the day.

Using the year or month number in the day position.

The third argument in DATE is the day. July 4 means day 4.

4fill in blank

hard

Fill 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'

A2025

B24

C12

D11

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping year and month numbers.

Using 11 instead of 12 for December.

The first blank is the year 2025, and the second blank is the month December (12).

5fill in blank

hard

Fill 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'

A2020

B2

C29

D28

Attempts:

3 left

💡 Hint

Common Mistakes

Using 28 instead of 29 for the day.

Using a non-leap year like 2019.

2020 is the leap year, 2 is February, and 29 is the day for leap day.

Practice

1. What does the DATE function do in Google Sheets?

easy

A. It creates a date from year, month, and day numbers.

B. It calculates the difference between two dates.

C. It converts text to uppercase.

D. It adds numbers together.

Solution

1. Step 1: Understand the purpose of DATE

   The DATE function takes three numbers: year, month, and day, and combines them into a valid date.

2. Step 2: Compare with other options

   Other options describe different functions like date difference or text conversion, which are not what DATE does.

3. Final Answer:

   It creates a date from year, month, and day numbers. -> Option A

4. Quick Check:

   DATE function = create date [OK]

Hint: DATE joins year, month, day into one date [OK]

Common Mistakes:

• Confusing DATE with functions like TODAY or NOW
• Thinking DATE calculates differences
• Assuming DATE formats text

2. Which of these is the correct syntax for the DATE function in Google Sheets?

easy

A. DATE(month, day, year)

B. DATE(day, month, year)

C. DATE(year, month, day)

D. DATE(year-day-month)

Solution

1. Step 1: Recall DATE function syntax

   The correct order is year first, then month, then day: DATE(year, month, day).

2. Step 2: Check other options

   Options B and C have wrong order; D uses invalid syntax with dashes and no commas.

3. Final Answer:

   DATE(year, month, day) -> Option C

4. Quick Check:

   Correct syntax = DATE(year, month, day) [OK]

Hint: Remember: year, month, day order in DATE [OK]

Common Mistakes:

• Swapping day and month positions
• Using dashes instead of commas
• Putting month first

3. What is the result of =DATE(2024, 13, 1) in Google Sheets?

medium

A. December 1, 2024

B. January 1, 2025

C. January 1, 2024

D. Error

Solution

1. Step 1: Understand month overflow in DATE

   The month value 13 means 1 month after December, so it moves to January of next year.

2. Step 2: Calculate the adjusted date

   So DATE(2024, 13, 1) becomes January 1, 2025.

3. Final Answer:

   January 1, 2025 -> Option B

4. Quick Check:

   Month 13 = January next year [OK]

Hint: Months >12 roll over to next year automatically [OK]

Common Mistakes:

• Expecting error for month 13
• Thinking month 13 means December
• Ignoring automatic date adjustment

4. You entered =DATE(2023, 2, 30) but it shows March 2, 2023. Why?

medium

A. February has only 28 or 29 days, so day 30 rolls into March.

B. DATE function has a bug showing wrong dates.

C. You must enter day before month in DATE.

D. Google Sheets does not support dates in February.

Solution

1. Step 1: Check day overflow behavior

   February usually has 28 or 29 days, so day 30 is invalid and rolls over to March 2.

2. Step 2: Understand DATE auto-adjustment

   DATE automatically adjusts invalid days by adding extra days to next month.

3. Final Answer:

   February has only 28 or 29 days, so day 30 rolls into March. -> Option A

4. Quick Check:

   Invalid day rolls over to next month [OK]

Hint: Invalid days push date into next month automatically [OK]

Common Mistakes:

• Thinking DATE has bugs
• Swapping day and month order
• Believing February dates are unsupported

5. You have year in A1=2023, month in B1=11, and day in C1=35. Which formula correctly gives the valid date?

hard

A. =DATE(A1, B1+1, C1-31)

B. =DATE(A1, B1, 30)

C. =DATE(A1, 12, C1)

D. =DATE(A1, B1, C1)

Solution

1. Step 1: Understand how DATE handles overflow

   DATE automatically adjusts day 35 in November to December 5 (35 - 30 = 5 days into next month).

2. Step 2: Check each option

   =DATE(A1, B1, C1) uses original values and lets DATE fix the date correctly. Others manually change month or day, which is unnecessary or incorrect.

3. Final Answer:

   =DATE(A1, B1, C1) -> Option D

4. Quick Check:

   DATE auto-fixes overflow days [OK]

Hint: Use DATE with raw values; it fixes overflow automatically [OK]

Common Mistakes:

• Manually adjusting month or day before DATE
• Assuming DATE errors on large day numbers
• Changing month without reason