MONTH function
MONTH pulls the month out of a date and returns it as a number from 1 to 12. It is handy in helper columns for grouping sales or events by month.
Example
Read it as a sentence: find the month of the date in F1. F1 is empty, which counts as day 0 of January 1900, so the answer is 1.
Excel shows 1
F
1
Data
Syntax
MONTH(serial_number)
-
serial_number(required) - A date or date serial number.
Returns: The month number, 1 to 12.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=MONTH(46031) | 1 | Serial |
=MONTH("2026-12-25") | 12 | ISO text |
=MONTH(0) | 1 | Serial 0 |
=MONTH(Data!F1) | 1 | Blank |
=MONTH(Data!F3) | 2 | Date cell |
=MONTH(-1) | #NUM! | Negative |
=MONTH("abc") | #VALUE! | Bad text |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
Data
Watch out for
- Gives a number, not a name; use TEXT(date,"mmmm") for the name.
- Months from different years share the same number, so combine with YEAR when grouping.
Where it works
- Excel
- MONTH is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .