Date Functions
Beginner
YEAR, MONTH, and DAY Functions
Extract year, month, and day from dates using YEAR, MONTH, and DAY.
Task:
You have a list of dates and need to extract the year, month, and day separately. Extract the year in column B, the month in column C, and the day in column D from the dates in column A using the YEAR, MONTH, and DAY functions.
Learning Objectives:
- Learn YEAR, MONTH, and DAY functions
- Understand date component extraction
- Practice date data analysis
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Year | Month | Day |
| 2 | 1/15/2023 | |||
| 3 | 5/20/2023 | |||
| 4 | 12/31/2023 |
What this exercise teaches (contains the answer)
YEAR, MONTH, and DAY functions are essential for extracting specific components from dates, which is useful for analysis, reporting, or data manipulation.