Introduction
The MONTH function in Excel extracts the month number from a valid date. For example, if a cell contains 15-Nov-2026, the MONTH function returns 11 because November is the eleventh month of the year.
It is useful for analysing monthly sales, preparing employee records, organising transaction dates, and creating monthly reports.
1. What Is the MONTH Function in Excel?
The MONTH function extracts the month from a given Excel date and returns it as a number between 1 and 12.
For example, suppose a company has an employee joining date:
| Joining Date |
|---|
| 15-Nov-2026 |
To extract only the month number, use:
=MONTH(A2)
Expected Result: 11
Excel reads the date and returns its month number.
2. MONTH Function Syntax
=MONTH(serial_number)
Let’s understand the argument.
| Argument | Meaning |
|---|---|
| serial_number | A valid Excel date from which you want to extract the month. |
For example:
=MONTH("15-Nov-2026")
Result: 11
The MONTH function requires only one argument.
3. Understanding Month Numbers in Excel
Excel represents the months of a year using numbers from 1 to 12.
| Month Number | Month Name |
|---|---|
| 1 | January |
| 2 | February |
| 3 | March |
| 4 | April |
| 5 | May |
| 6 | June |
| 7 | July |
| 8 | August |
| 9 | September |
| 10 | October |
| 11 | November |
| 12 | December |
For example:
=MONTH("10-Jan-2026")
Result: 1
=MONTH("20-Aug-2026")
Result: 8
=MONTH("25-Dec-2026")
Result: 12
Important: MONTH returns the numerical month, not its name. If you provide a date in November, the result is 11, not November.
4. How Does the MONTH Function Work?
Excel stores valid dates internally as serial numbers. When you provide a date to MONTH, Excel reads the date and extracts its month component.
Suppose cell A2 contains 20-Aug-2026.
=MONTH(A2)
Excel reads the date as follows:
| Date Component | Value |
|---|---|
| Day | 20 |
| Month | 8 |
| Year | 2026 |
Final Result: 8
The original date remains unchanged. Only the month number is returned.
Important Points to Remember
- MONTH returns a number from 1 to 12.
- January is represented by 1.
- December is represented by 12.
- The input should be a valid Excel date.
- If Excel cannot recognise the supplied value as a date, it may return a
#VALUE!error. - The result is a number, not a month name.
Practical MONTH Function Examples
Question 1: Extract Month from a Date
Problem Statement
A company wants to extract the month number from an employee’s joining date.
Data
| Employee | Joining Date |
|---|---|
| Amit | 15-Nov-2026 |
Assume the joining date is in cell B2.
Excel Formula
=MONTH(B2)
Expected Result
11
Explanation
The date in B2 is 15-Nov-2026.
November is the eleventh month of the year, so Excel returns 11.
Concept Covered: Extracting a month number from a date.
Question 2: Extract Months from Multiple Employee Joining Dates
Problem Statement
An HR department wants to identify the joining month of every employee.
Data
| Employee | Joining Date |
|---|---|
| Amit | 15-May-2022 |
| Neha | 10-Feb-2023 |
| Rahul | 20-Aug-2024 |
| Priya | 05-Jan-2025 |
| Karan | 12-Nov-2026 |
Assume joining dates are in column B.
Excel Formula
=MONTH(B2)
Expected Results
| Employee | Joining Date | Month Number |
|---|---|---|
| Amit | 15-May-2022 | 5 |
| Neha | 10-Feb-2023 | 2 |
| Rahul | 20-Aug-2024 | 8 |
| Priya | 05-Jan-2025 | 1 |
| Karan | 12-Nov-2026 | 11 |
Explanation
Enter the formula in C2 and copy it down for the remaining employees.
Excel extracts the month number from each joining date.
Concept Covered: Extracting month numbers from multiple records.
Question 3: Extract Month from Sales Transaction Dates
Problem Statement
A sales manager wants to identify the month number of every sales transaction.
Data
| Transaction ID | Transaction Date | Sales |
|---|---|---|
| T101 | 10-Mar-2024 | 25000 |
| T102 | 15-Jul-2024 | 30000 |
| T103 | 20-Jan-2025 | 45000 |
| T104 | 12-Sep-2025 | 50000 |
| T105 | 05-Nov-2026 | 60000 |
Assume transaction dates are in column B.
Excel Formula
=MONTH(B2)
Expected Results
| Transaction ID | Transaction Date | Sales | Month Number |
|---|---|---|---|
| T101 | 10-Mar-2024 | 25000 | 3 |
| T102 | 15-Jul-2024 | 30000 | 7 |
| T103 | 20-Jan-2025 | 45000 | 1 |
| T104 | 12-Sep-2025 | 50000 | 9 |
| T105 | 05-Nov-2026 | 60000 | 11 |
Explanation
MONTH reads each transaction date and returns its month number.
For example, March is 3, July is 7, and November is 11.
Concept Covered: Extracting month numbers from sales records.
Question 4: Extract Month from Student Admission Dates
Problem Statement
A school wants to identify the admission month of every student.
Data
| Student | Admission Date |
|---|---|
| Rohan | 05-Apr-2023 |
| Simran | 12-Jun-2024 |
| Mohit | 18-Jul-2025 |
| Pooja | 20-Mar-2026 |
Assume admission dates are in column B.
Excel Formula
=MONTH(B2)
Expected Results
| Student | Admission Date | Month Number |
|---|---|---|
| Rohan | 05-Apr-2023 | 4 |
| Simran | 12-Jun-2024 | 6 |
| Mohit | 18-Jul-2025 | 7 |
| Pooja | 20-Mar-2026 | 3 |
Explanation
The MONTH function extracts only the month number from each student’s admission date.
Concept Covered: Extracting admission months from student records.
Question 5: Extract Month from a Date Entered Directly in the Formula
Problem Statement
A user wants to extract the month number from a specific date without referring to another cell.
Excel Formula
=MONTH("25-Dec-2025")
Expected Result
12
Explanation
The date is entered directly inside the formula. Excel recognises the date and MONTH returns 12 because December is the twelfth month.
Concept Covered: Providing a date directly to the MONTH function.
Question 6: Identify the Month of a Project Completion Date
Problem Statement
A company stores project completion dates and wants to identify the month in which each project was completed.
Data
| Project | Completion Date |
|---|---|
| Website Development | 18-Aug-2025 |
| Mobile Application | 10-Feb-2026 |
| Database Migration | 25-Nov-2026 |
| Software Testing | 15-Apr-2026 |
Assume completion dates are in column B.
Excel Formula
=MONTH(B2)
Expected Results
| Project | Completion Date | Completion Month |
|---|---|---|
| Website Development | 18-Aug-2025 | 8 |
| Mobile Application | 10-Feb-2026 | 2 |
| Database Migration | 25-Nov-2026 | 11 |
| Software Testing | 15-Apr-2026 | 4 |
Explanation
The formula reads each completion date and returns only its month number.
For example, August returns 8 and April returns 4.
Concept Covered: Extracting project completion months.
Question 7: Extract Month from Dates Across Different Years
Problem Statement
A company has transaction records from different years. The manager wants to extract the month number from each transaction date.
Data
| Record | Transaction Date |
|---|---|
| Record A | 15-Aug-1995 |
| Record B | 20-Jan-2000 |
| Record C | 10-Jun-2010 |
| Record D | 25-Dec-2026 |
Assume dates are in column B.
Excel Formula
=MONTH(B2)
Expected Results
| Record | Transaction Date | Month Number |
|---|---|---|
| Record A | 15-Aug-1995 | 8 |
| Record B | 20-Jan-2000 | 1 |
| Record C | 10-Jun-2010 | 6 |
| Record D | 25-Dec-2026 | 12 |
Explanation
MONTH extracts the month from each valid date, regardless of the year.
For example, January returns 1 whether the date belongs to 2000 or 2026.
Concept Covered: Extracting months from dates belonging to different years.
Student Practice Tasks
Try these tasks using the MONTH function.
Task 1: Employee Joining Month
Extract the month number from every employee’s joining date.
Task 2: Sales Transaction Month
Create a separate column showing the month number of every sales transaction.
Task 3: Student Admission Month
Extract the admission month from student admission dates.
Task 4: Project Completion Month
Display only the month number from each project’s completion date.
Task 5: Different Year Records
Extract month numbers from dates belonging to different years.
Final Student Challenge: Build a Monthly Employee Report
An HR department wants to prepare a report showing the joining month of every employee.
Employee Data
| Employee | Department | Joining Date |
|---|---|---|
| Amit | IT | 15-Mar-2021 |
| Neha | HR | 20-Jun-2022 |
| Rahul | Finance | 10-Jan-2023 |
| Priya | IT | 25-Aug-2024 |
| Karan | Sales | 05-Feb-2025 |
| Simran | HR | 18-Nov-2026 |
Your Challenge
- Add a new column named Joining Month.
- Extract the month number from every joining date.
- Apply the formula to all employees.
- Add two new employee records with different joining dates.
- Extract their joining month numbers as well.
Goal: Create an employee joining-month report using the MONTH function.
Key Takeaways
- MONTH extracts the month number from a valid Excel date.
- Its syntax is
=MONTH(serial_number). - It requires only one argument.
- The result is always between 1 and 12 for normal calendar dates.
- January is 1 and December is 12.
- You can use cell references or recognised date values.
- MONTH is useful for sales, employee, student, and project reports.
- The function does not change the original date.
Frequently Asked Questions (FAQs)
1. What is the MONTH function in Excel?
The MONTH function extracts the month number from a valid Excel date.
2. What is the syntax of the MONTH function?
The syntax is =MONTH(serial_number), where serial_number represents a valid date.
3. What does MONTH return for November?
MONTH returns 11 for any valid date in November.
4. Can MONTH extract the month from a cell reference?
Yes. If A2 contains a valid date, =MONTH(A2) returns its month number.
5. Does MONTH return the month name?
No. MONTH returns a number between 1 and 12, not the month name.
6. Can MONTH work with dates from different years?
Yes. It extracts the month regardless of the year.
7. Why does MONTH return a #VALUE! error?
This can happen when the supplied value is text that Excel cannot recognise as a valid date.
8. Does MONTH change the original date?
No. It only extracts and returns the month number. The original date remains unchanged.
9. Can MONTH be used in sales and employee reports?
Yes. It is useful for identifying transaction months, employee joining months, admission months, and project completion months.
10. What is the result of MONTH for December?
The result is 12 because December is the twelfth month of the year.

