YEAR, MONTH, DAY extraction in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=YEAR([1])

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

AB1

BA1

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.

Excel

=MONTH([1])

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

AB2

BTODAY()

CC2

DA2

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference.

Confusing MONTH with DAY or YEAR functions.

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.

Excel

=DAY([1])

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

ADATE

BC4

CNOW()

DC3

Attempts:

3 left

💡 Hint

Common Mistakes

Referencing a cell without a date.

Using a function name instead of a cell reference.

The DAY function extracts the day part from the date in cell C3. Using the correct cell reference is important.

4fill in blank

hard

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

Excel

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

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

AD4

BE4

CD5

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using different cells for YEAR and MONTH causing inconsistent results.

Referencing a cell without a date.

Both YEAR and MONTH functions should reference the same cell D4 to extract year and month from the same date.

5fill in blank

hard

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

Excel

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

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

AE5

BF5

CG5

DTODAY()

Attempts:

3 left

💡 Hint

Common Mistakes

Using different cells for each function causing wrong date parts.

Using a function name instead of a cell reference.

All three functions YEAR, MONTH, and DAY should reference the same cell E5 to extract the date parts correctly.