Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 3/6

YEAR, MONTH, DAY, WEEKDAY

Exercise 1 of 4

In B2, take the year from the date.

About this lesson

YEAR, MONTH, DAY and WEEKDAY take a date apart into its pieces.

In this lesson

  1. In B2, take the year from the date.
  2. In B2, take the month number from the date.
  3. In B2, take the day of the month from the date.
  4. In B2, work out the day of the week, with Monday as 1 and Sunday as 7.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.