MONTH Function
Returns the month number from a date.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A number from 1 to 12
Overview
MONTH returns the month of a date as a number, 1 (January) to 12 (December).
It's the quickest way to group or filter dates by month in a helper column.
Syntax
=MONTH(serial_number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | The date to read. |
Examples
Example 1 — Month of each order
Add a helper column so orders can be summarised by month.
B2fx=MONTH(A2)
| A | B | |
|---|---|---|
| 1 | Order date | Month |
| 2 | 3/15/2026 | 3 |
| 3 | 7/4/2026 | 7 |
| 4 | 12/31/2026 | 12 |
=MONTH(A2) Explain
Example 2 — Total sales for March
Count only the rows whose month is 3.
=SUMPRODUCT((MONTH(A2:A100)=3)*B2:B100) Explain
For the month's name instead of its number, use =TEXT(A2, "mmmm") (March) or "mmm" (Mar).
Common mistakes
- March of every year gets lumped together. MONTH ignores the year. Check YEAR as well, or use SUMIFS with a start and end date.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.