YEAR, MONTH, DAY extraction in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to extract the year from a date in cell A1.

Google Sheets

=YEAR([1])

Drag options to blanks, or click blank then click option'

AA1

BB1

CDATE

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using a function name instead of a cell reference.

Referencing the wrong cell.

The YEAR function extracts the year part from the date in cell A1.

2fill in blank

medium

Complete the formula to extract the month from a date in cell B2.

Google Sheets

=MONTH([1])

Drag options to blanks, or click blank then click option'

ANOW()

BDATE

CB2

DA2

Attempts:

3 left

💡 Hint

Common Mistakes

Using a function name instead of a cell reference.

Referencing the wrong cell.

The MONTH function extracts the month part from the date in cell B2.

3fill in blank

hard

Fix the error in the formula to extract the day from a date in cell C3.

Google Sheets

=DAY([1])

Drag options to blanks, or click blank then click option'

AC3

BC4

CDATE

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Referencing the wrong cell.

Using a function name instead of a cell reference.

The DAY function extracts the day part from the date in cell C3. Using C4 or a function name will give wrong results.

4fill in blank

hard

Fill both blanks to create a formula that extracts the year and month from cell D5 and combines them as "Year-Month".

Google Sheets

=YEAR([1])&"-"&MONTH([2])

Drag options to blanks, or click blank then click option'

AD5

BE5

CF5

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using different cells for year and month.

Using a function name instead of a cell reference.

Both YEAR and MONTH functions should reference the same date cell D5 to combine year and month correctly.

5fill in blank

hard

Fill all three blanks to create a formula that extracts year, month, and day from cell E7 and formats them as "YYYY/MM/DD".

Google Sheets

=YEAR([1])&"/"&TEXT(MONTH([2]), "00")&"/"&TEXT(DAY([3]), "00")

Drag options to blanks, or click blank then click option'

AE7

BF7

CG7

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using different cells for year, month, and day.

Not using TEXT to format month and day with two digits.

All parts must reference the same date cell E7 to correctly format the date as YYYY/MM/DD with leading zeros for month and day.