1. What is the MONTH Function & How Does It Work?
The MONTH function takes a valid date serial number and extracts the month integer value from 1 (January) to 12 (December).
Formula Anatomy: The Parameter of MONTH()
=MONTH( serial_number )1. SERIAL_NUMBER (REQUIRED)
Which cell contains the date?
The cell reference (e.g. A2) or valid date string to extract month from.
A2 = "2026-08-12" ➔ Returns 82. Real-World Analytics Scenarios for MONTH
📊 Scenario A: Seasonal Sales Trend Grouping
Group retail orders by month integer (1-12) to detect summer vs winter sales spikes.
=MONTH(A2)🌐 Scenario B: Computing Fiscal Quarters (Q1-Q4)
Divide month number by 3 and round up to assign sales to Q1, Q2, Q3, or Q4.
="Q" & ROUNDUP(MONTH(A2)/3, 0)✍️ Scenario C: Text Month Name Extraction
Convert dates into readable 3-letter month abbreviations ("Aug") or full names ("August").
=TEXT(A2, "mmmm") ➔ "August"🎮 Live Interactive MONTH & Quarter Inspector
Pick any date to see =MONTH(A2), full Month Name, and Fiscal Quarter evaluate instantly!
EVALUATED MONTH & QUARTER:Month 8 (August) ➔ Q3
📊 Generated Excel Formula
=MONTH(A2) & " (" & TEXT(A2, "mmmm") & " - " & "Q" & ROUNDUP(MONTH(A2)/3,0) & ")"🧪 Knowledge Check — MONTH Function Quiz
Question 1 of 5Score: 0