MONTH
Converts a serial number to a month.
Date & TimeDates & Time CalculationsMost Used
What it does
Returns the month number (1–12) from a date.
Syntax
MONTH(serial_number)
Arguments
serial_number(date) — Date to extract from.
Examples
Extract month
Get the month from A2.
FORMULA
=MONTH(A2)
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-03-15 |
| 3 | 2025-12-31 |