Extract date parts from a date
BeginnerDate fields are often used for filtering, grouping, and reporting. In this exercise, you will extract separate month, day, and year values from each date.
Use these functions:
=MONTH(date)=DAY(date)=YEAR(date)
For example, =YEAR("2023-7-22") returns 2023.
What you need to do
- Fill column C with the month number from column B.
- Fill column D with the day number from column B.
- Fill column E with the year from column B.
Goal
Each row should show month, day, and year values extracted from the date in column B.
Need some help?
Hint 1
Use MONTH, DAY, and YEAR on the date in the same row.
Hint 2
The DATE function shown in column B creates a real date value from year, month, and day inputs.
Hint 3
Start in row 2, then copy across and down so each row returns month, day, and year from column B.
Extract date parts from a date
BeginnerDate fields are often used for filtering, grouping, and reporting. In this exercise, you will extract separate month, day, and year values from each date.
Use these functions:
=MONTH(date)=DAY(date)=YEAR(date)
For example, =YEAR("2023-7-22") returns 2023.
What you need to do
- Fill column C with the month number from column B.
- Fill column D with the day number from column B.
- Fill column E with the year from column B.
Goal
Each row should show month, day, and year values extracted from the date in column B.
Need some help?
Hint 1
Use MONTH, DAY, and YEAR on the date in the same row.
Hint 2
The DATE function shown in column B creates a real date value from year, month, and day inputs.
Hint 3
Start in row 2, then copy across and down so each row returns month, day, and year from column B.