BBampaa

Lessons › Excel & Google Sheets

Excel & Google Sheets lesson

MONTH, YEAR and DAY

3, for March. Handy for grouping orders by month.

Try this lesson free →
About 5–10 minutes · no sign-up needed

Example

MONTH pulls the month number out of a date. YEAR and DAY work the same way:

=MONTH(B2)

Typed into cell D2 of this sheet:

OrderOrderedDeliveredMonthDay
O101{'date': '2024-03-01'}{'date': '2024-03-04'}
O102{'date': '2024-03-04'}{'date': '2024-03-08'}
O103{'date': '2024-03-05'}{'date': '2024-03-06'}
O104{'date': '2024-03-07'}{'date': '2024-04-02'}
O105{'date': '2024-03-11'}{'date': '2024-03-13'}

Key points

MONTH(B2)The month number: 3 for March.
YEAR(B2)The year: 2024.
DAY(B2)The day of the month: 1.

Put together: =MONTH(B2), =YEAR(B2), =DAY(B2).

Practice

Try each one in your head first, then open the answer.

1. In D3, show the month number of order O102.
=MONTH(B3)
2. In E2, show the day of the month order O101 was placed.
=DAY(B2)
3. In D5, show the month number O104 was delivered.
=MONTH(C5)
4. In E6, show the day of the month O105 was delivered.
=DAY(C6)
5. In D6, show the year order O105 was placed.
=YEAR(B6)

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed