ReferenceFunctionsDate & Time Functions
MONTH
Extracts the month number (`1` to `12`) from a date serial.
Summary
Extracts the month number (1 to 12) from a date serial.
Remarks
- Fractional time is ignored; only the date portion contributes.
- Serials are interpreted with Excel 1900 date semantics.
- The result always uses January=
1through December=12.
Examples
Extract month from January date
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
1
Extract month from leap-day serial
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
2
Related functions
FAQ
Can MONTH return values outside 1 through 12?
No. MONTH always returns an integer from 1 to 12 after serial-to-date conversion.
Runtime metadata
Category
Date & Time
Signature
MONTH(arg1: Number)Arity
min 1, max 1
Arguments
arg1Number · Scalar · coercion NumberLenientText
Caps
PURE
Source