1. Core Concept & Syntax
The MONTH function in Microsoft Excel extracts the month corresponding to a valid date serial number as an integer between 1 (January) and 12 (December).
=MONTH(serial_number)
serial_number: A valid Excel date (cell reference like A2 or formula like TODAY()).
Returns an integer from 1 (Jan) to 12 (Dec).
Returns the number 8, not the text string "August".
Example:
2. 🔥 Live Interactive — Extract Month Number
Task: Extract the month number from each employee's joining date using =MONTH(B2):
| # | A (Employee) | B (Joining Date - Editable) | C (=MONTH(B2)) Extracted Month |
|---|---|---|---|
| 2 | Amit | =MONTH(B2) | |
| 3 | Priya | =MONTH(B2) | |
| 4 | Rahul | =MONTH(B2) | |
| 5 | Neha | =MONTH(B2) |
3. 🔥 Live Practice — Month-Based Order Filtering
Task: Extract the month number from each order date to identify all orders placed in March (Month = 3):
| # | A (Order ID) | B (Order Date) | C (Sales Amount) | D (=MONTH(B2)) Month | E (March Target Match) |
|---|---|---|---|---|---|
| 2 | ORD101 | 2026-01-05 | ₹45,000 | — | — |
| 3 | ORD102 | 2026-03-12 | ₹52,000 | — | — |
| 4 | ORD103 | 2026-03-20 | ₹61,000 | — | — |
| 5 | ORD104 | 2026-08-15 | ₹48,000 | — | — |
| 6 | ORD105 | 2026-12-25 | ₹75,000 | — | — |
4. Combining MONTH() with IF for Fiscal Quarters
Business Logic: Identify orders placed during the first quarter (Q1: January to March) using =IF(AND(MONTH(B2)>=1, MONTH(B2)<=3), "Q1", "Other"):
| Order ID | Order Date | Month (=MONTH) | Status (=IF(AND(MONTH>=1, MONTH<=3)...)) |
|---|---|---|---|
| ORD101 | 2026-01-05 | — | — |
| ORD102 | 2026-03-12 | — | — |
| ORD103 | 2026-07-20 | — | — |
| ORD104 | 2026-12-15 | — | — |
5. 🔥 Practical Business Use: Monthly Transaction Analysis
Task: Extract month integers across transaction logs to identify all March transactions without manual inspection:
| TX ID | Transaction Date | Sales | Extracted Month (=MONTH) | March Match Status |
|---|---|---|---|---|
| TX001 | 2026-01-05 | ₹25,000 | — | — |
| TX002 | 2026-01-18 | ₹31,000 | — | — |
| TX003 | 2026-02-12 | ₹42,000 | — | — |
| TX004 | 2026-03-20 | ₹38,000 | — | — |
| TX005 | 2026-03-15 | ₹55,000 | — | — |
| TX006 | 2026-04-10 | ₹62,000 | — | — |
6. 🔥 Live Interactive: Month Change Sandbox
Test how MONTH() dynamically responds to date changes:
7. MONTH() vs Month Name String
Understand the distinction between numeric month integers and textual month names:
Outputs an integer (8) designed for mathematical logic, quarter calculations (ROUNDUP(Month/3, 0)), and numerical comparisons (>= 7).
Outputs the text string "August" for human-readable dashboard titles. It cannot be used in numerical inequalities!
8. 🔥 Real Data-Quality: Flag Second-Half (H2) Records
Business Rule: Identify transactions that occurred during the second half of the year (July to December: Month >= 7) using =IF(MONTH(B2)>=7, "H2", "H1"):
| Record ID | Transaction Date (Editable) | Extracted Month | Half-Year Status |
|---|---|---|---|
| R001 | — | — | |
| R002 | — | — | |
| R003 | — | — | |
| R004 | — | — |
9. 🔥 Monthly Reporting: Filter January Sales
Populate the Month column to organize sales data for monthly reporting:
| Sale ID | Sale Date | Amount | Extracted Month (=MONTH) |
|---|---|---|---|
| S001 | 2026-01-05 | ₹12,000 | — |
| S002 | 2026-01-18 | ₹18,000 | — |
| S003 | 2026-02-10 | ₹15,000 | — |
| S004 | 2026-02-22 | ₹21,000 | — |
| S005 | 2026-03-12 | ₹17,000 | — |
10. 🔥 Debugging Challenge: Fix MONTH() Mistakes
Diagnose and fix these common formula errors:
11. Important: Valid Date Serial vs Text Dates
MONTH() requires a valid Excel date serial number. If a date was imported from a CSV with periods or apostrophes (e.g. '2026.03.15), MONTH() will throw a #VALUE! error.
Valid date serial numbers align to the RIGHT of the cell by default. Left-aligned date strings indicate raw text.
12. 🔥 Live Final Challenge: Monthly Reporting Audit
Task: Enter =MONTH(B2) to extract all 6 transaction months and classify transactions into seasonal reporting buckets:
| # | A (TX ID) | B (Transaction Date - Editable) | C (Amount) | D (=MONTH(B2)) Extracted Month | E (Seasonal Bucket) |
|---|---|---|---|---|---|
| 2 | TX001 | ₹25,000 | — | — | |
| 3 | TX002 | ₹31,000 | — | — | |
| 4 | TX003 | ₹42,000 | — | — | |
| 5 | TX004 | ₹38,000 | — | — | |
| 6 | TX005 | ₹55,000 | — | — | |
| 7 | TX006 | ₹62,000 | — | — |
13. Quick Check Assessment Quiz
Test your understanding of the MONTH() formula syntax and seasonal reporting rules:
Excel MONTH() Assessment Quiz
Test your mastery of month extraction, range rules (1–12), and quarterly IF logic.
1. What value does the Excel formula =MONTH(A2) return when A2 contains "15/08/2026"?
14. Accuracy & Production Best Practices
Key takeaways for building month-sensitive reporting templates:
- Always use MONTH() for Calculations: Never rely on visual date formatting when writing logical rules or calculating quarters.
- Calculating Fiscal Quarters: Calculate quarters mathematically via
=ROUNDUP(MONTH(A2)/3, 0)(Months 1–3 ➔ Q1, Months 4–6 ➔ Q2, etc.). - Dynamic Current Month: Use
=MONTH(TODAY())to extract the ongoing calendar month number.