Date & Time
Modern
MONTH
Extracts the month number (1–12) from a date.
Available in All versions
Syntax
MONTH(serial_number)What it returns
The month number, 1 to 12.
Arguments
| Argument | Required | Description |
|---|---|---|
serial_number |
Yes | The date to read the month from. |
Example
| A | |
|---|---|
| 1 | Date |
| 2 | 06/11/2026 |
Result
6
MONTH reads the month number out of a date (6).
=MONTH(A2)Important to know
Returns 1–12, not the month name — use TEXT for the name.
Input must be a valid Excel date.