Dates·Lesson 47 of 62Pro
How to use MONTH in Google Sheets
Get the month
How MONTH works
MONTH returns the month of a date as a number from 1 to 12. YEAR and DAY work the same way.
MONTH(date)
Example on this data
=DAY(G5)→2
DAY works the same: the day of the month.
What you’ll do
You’ll pull the month out of an order date. Splitting dates into parts lets you group and total by month.
Try it
Type =DAY(G5) into K2 and press Enter. Watch what the sheet does.
The result will appear in K2.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Rep | Region | Product | Units | Price | Order date | Ship date | |||
| 2 | 1001 | Ana | West | Desk | 3 | 240 | 1/5/2026 | 1/9/2026 | |||
| 3 | 1002 | Bo | East | Chair | 8 | 85 | 1/12/2026 | 1/20/2026 | |||
| 4 | 1003 | Cy | West | Lamp | 12 | 30 | 1/19/2026 | 1/22/2026 | |||
| 5 | 1004 | Di | North | Desk | 2 | 240 | 2/2/2026 | 2/13/2026 | |||
| 6 | 1005 | Ana | West | Chair | 5 | 85 | 2/9/2026 | 2/12/2026 | |||
| 7 | 1006 | Eve | South | Shelf | 4 | 120 | 2/16/2026 | 2/27/2026 | |||
| 8 | 1007 | Bo | East | Lamp | 20 | 30 | 3/2/2026 | 3/4/2026 | |||
| 9 | 1008 | Cy | West | Shelf | 1 | 120 | 3/9/2026 | 3/18/2026 | |||
| 10 | 1009 | Di | North | Chair | 6 | 85 | 3/16/2026 | 3/19/2026 | |||
| 11 | 1010 | Eve | South | Desk | 7 | 240 | 3/23/2026 | 4/1/2026 |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how MONTH works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In K2, show the month number of the order date in G2.
One payment, no subscription.