MONTH pulls the month out of a date: given 2026-11-16 it returns 11. Like YEAR and DAY it reads an Excel date serial and returns a plain number 1–12. Use it to group by month, build month labels, or drive seasonal logic.
Returns a number 1–12. The month of the given date.
The middle part of a date. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =MONTH(C2) | 11 | Month of 2026-11-16 |
| =MONTH(C3) | 1 | January |
| =MONTH(C5) | 12 | December |
| =MONTH(C8) | 2 | February of a leap year |
| =MONTH(DATE(2026,11,16)) | 11 | From a constructed date |
| =TEXT(C2,"yyyy")&"-"&TEXT(C2,"mm") | 2026-11 | Zero-padded year-month |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to extract the month from a date.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
MONTH is a core date function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
MONTH is one piece. The full course walks the toolkit end to end with live, measured examples.