YEAR, MONTH, DAY extraction in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the YEAR function do in Excel?

The YEAR function extracts the year part from a date and returns it as a number. For example, YEAR("2024-06-15") returns 2024.

beginner

How do you extract the month from a date in Excel?

Use the MONTH function. It returns the month number (1 to 12) from a date. For example, MONTH("2024-06-15") returns 6.

beginner

What is the purpose of the DAY function in Excel?

The DAY function extracts the day number from a date. For example, DAY("2024-06-15") returns 15.

beginner

If cell A1 contains the date 2024-12-25, what formula extracts the year?

Use =YEAR(A1). It will return 2024.

intermediate

Can YEAR, MONTH, and DAY functions work with text dates?

Yes, if the text is in a recognizable date format. Excel converts it to a date internally. Otherwise, it may give an error.

What does the formula =MONTH("2024-11-05") return?

A 5

B 2024

C 11

D Error

MONTH extracts the month number from the date, which is 11 for November.

Which function extracts the day from a date in Excel?

A MONTH

B DAY

C YEAR

D DATE

DAY returns the day number from a date.

If A1 contains 2023-03-10, what does =YEAR(A1) return?

A 2023

B 10

C Error

D 3

YEAR extracts the year part, which is 2023.

What happens if you use DAY on a cell with text 'Hello'?

A Returns an error

B Returns the day number

C Returns 0

D Returns the text 'Hello'

DAY expects a date. Text that is not a date causes an error.

Which formula extracts the month from a date in cell B2?

A =DAY(B2)

B =YEAR(B2)

C =DATE(B2)

D =MONTH(B2)

MONTH(B2) extracts the month number from the date in B2.

Explain how to extract the year, month, and day from a date in Excel.

Think about the three separate functions that each pull a part of the date.

Describe what happens if you use YEAR, MONTH, or DAY on a text string that looks like a date.

Consider how Excel handles text that looks like dates.