Date FunctionsBeginner

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.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of YEAR, MONTH, DAY

0/3

The same formula in the other shapes it takes at work.

  1. YEAR, MONTH, and DAY Functions

    Extract year, month, and day from dates using YEAR, MONTH, and DAY.

    CoreBeginner
  2. A quarter label from a date

    MONTH divided by 3, rounded up, is the quarter.

    Intermediate
  3. Rebuild a date one year on

    Take a date apart, change one piece, put it back with DATE.

    Intermediate

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.

4 rows × 4 columns9 cells you fill in
ABCD
1DateYearMonthDay
21/15/2023
35/20/2023
412/31/2023

Functions used here

What this exercise teachesMay contain the answer

YEAR, MONTH, and DAY functions are essential for extracting specific components from dates, which is useful for analysis, reporting, or data manipulation.