Recall & Review
beginner
What does the YEAR function do in Google Sheets?
The YEAR function extracts the year part from a date. For example, YEAR(DATE(2024,6,15)) returns 2024.
Click to reveal answer
beginner
How do you extract the month from a date in Google Sheets?
Use the MONTH function. For example, MONTH(DATE(2024,6,15)) returns 6, which is June.
Click to reveal answer
beginner
What is the purpose of the DAY function in Google Sheets?
The DAY function extracts the day number from a date. For example, DAY(DATE(2024,6,15)) returns 15.
Click to reveal answer
beginner
How would you extract the year, month, and day from a date in cell A1?
Use =YEAR(A1) for year, =MONTH(A1) for month, and =DAY(A1) for day.
Click to reveal answer
beginner
If a cell contains the date 12/25/2023, what will =MONTH(cell) return?
It will return 12, because December is the 12th month.
Click to reveal answer
What does the formula =YEAR("2023-11-05") return?
✗ Incorrect
YEAR extracts the year part, so it returns 2023.
Which function extracts the month from a date in Google Sheets?
✗ Incorrect
MONTH() extracts the month number from a date.
If cell A1 has the date 2024-02-14, what does =DAY(A1) return?
✗ Incorrect
DAY() extracts the day number, which is 14.
What will =MONTH("2023-07-01") return?
✗ Incorrect
MONTH() returns the month number, which is 7 for July.
Which formula extracts the year from a date in cell B2?
✗ Incorrect
YEAR(B2) extracts the year part from the date in B2.
Explain how to extract the year, month, and day from a date in Google Sheets.
Think about the separate functions for each part of the date.
You got /4 concepts.
Describe a real-life situation where extracting the year, month, or day from a date in a spreadsheet might be useful.
Consider how businesses or people use dates to organize information.
You got /3 concepts.