Syntax
MONTH(serial_number)
| Parameter | Description |
|---|---|
| serial_number | Parameter of the MONTH function. |
Examples
Extract month from a date
Formula
=MONTH(A2)
Returns: 3 — March, the month portion of the date in A2
Get month name from date
Formula
=TEXT(A2, "MMMM")
Returns: "March" — the full month name (use "MMM" for "Mar")
Determine fiscal quarter
Formula
=ROUNDUP(MONTH(A2)/3, 0)
Returns: 1 for Jan-Mar, 2 for Apr-Jun, 3 for Jul-Sep, 4 for Oct-Dec
Common Errors
#VALUE!
The cell does not contain a valid date. Text strings that look like dates need to be converted with DATEVALUE() first.
Tips
Month name lookup
=TEXT(DATE(2024, A1, 1), "MMMM") converts a month number to its name. Or use =CHOOSE(MONTH(A1), "Jan","Feb", ...).
Same month comparison
Filter for the current month: =IF(MONTH(A2)=MONTH(TODAY()), "Current Month", "Other").
Quarter calculation
=INT((MONTH(A1)-1)/3)+1 gives the quarter number (1-4) for any date.
Try MONTH in Viztab
Import your data and use MONTH with 370+ other formulas. No signup required.
Open Viztab