MONTH function

The MONTH function in Excel is used to extract the month from a given date. It returns the month as an integer between 1 and 12, where 1 represents January, 2 represents February, and so on through 12, which represents December.

Syntax

MONTH(serial_number)

Parameters

• serial_number: A valid Excel date or date-time value from which you want to extract the month. This can be a reference to a cell containing a date, a date expressed as text in a valid date format, or a date created using the DATE function.

How It Works

• Excel stores dates as serial numbers, where the integer part represents the date, and the decimal part represents the time.
• The MONTH function looks at the serial number of the date and extracts the month portion.

Examples

1. Extracting the Month from a Date: If you have the date March 15, 2025 in cell A1, and you want to extract the month, use:

   =MONTH(A1)
   

   Result: 3 (since March is the 3rd month of the year).

2. Using a Date in a Formula: If you want to extract the month from the date July 4, 2025:

   =MONTH("2025-07-04")
   

   Result: 7 (since July is the 7th month of the year).

3. Using the TODAY() Function: To extract the month from the current date, you can use the TODAY() function:

   =MONTH(TODAY())
   

   This will return the month number of the current date.

4. Using a Date-Time Value: If cell A1 contains a date-time value like 2025-05-01 18:45:00, and you want to extract the month:

   =MONTH(A1)
   

   Result: 5 (since the month is May).

Common Use Cases

• Month-based Analysis: The MONTH function is frequently used to categorize or analyze data based on months, such as creating monthly reports or tracking monthly trends.
• Conditional Logic: You can use the MONTH function within IF statements or other conditional formulas to apply logic based on the month of a date (e.g., to identify if a date falls in the first quarter of the year).
• Time Series Data: When working with time series data or sales data over months, the MONTH function helps group and analyze data on a monthly basis.

Important Notes

• The MONTH function returns an integer between 1 and 12, corresponding to the month of the year. It will not return any part of the date, such as the day or year.
• If the serial_number is not a valid date or is a text string that does not represent a valid date, the MONTH function will return a #VALUE! error.

Error Handling

If the serial_number is not a valid date or date-time value, you can handle the error using the IFERROR function:

=IFERROR(MONTH(A1), "Invalid Date")

This will return “Invalid Date” if the value in cell A1 is not a valid date.

Summary

The MONTH function in Excel is a simple and effective tool for extracting the month from a given date. It is commonly used for month-based categorization, time series analysis, and in conditional formulas to perform month-specific calculations or logic. The function works in combination with other date functions to manipulate and analyze date-time data in Excel.