Get the month with MONTH
PremiumTo total sales by month you need the month number of each sale. In B2, use MONTH to get it from the date in A2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Sale date | Month | ||||
| 2 | Mar 15, 2024 | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Dates and DATE and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
It comes up in this mock test: Excel test for finance jobs
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
Why this works
MONTH returns the month of a date as a number from 1 to 12, so Mar 15, 2024 gives 3. YEAR and DAY work the same way for the year and the day. With a Month column you can total each month with SUMIF.
Common mistake: Using LEFT or MID on a date to cut out the month. The cell holds the number 45366, not the text you see.
The answer
- B2
=MONTH(A2)