MONTH function

Excel MONTH Function is a simple yet powerful tool that allows you to extract the month from a given date. It’s useful for various tasks, like organizing data, creating reports, or analyzing trends.




serial_numberThe date from which you want to extract the month.

How to use

The Excel MONTH function is straightforward to use. You provide it with a date, and it returns the month as a number between 1 and 12. Here’s how to use it:

In this example, “A1” contains a date, and the formula will return the month as a number. If “A1” holds the date “2023-11-03,” the formula will return “11,” representing November.

Remember, this function can be helpful in various scenarios, such as sorting data by month, creating date-based charts, or analyzing seasonal patterns in your data.


Let’s look at a few examples to see how the Excel MONTH function works:

This formula will return “11” because it’s extracting the month from the date “2023-11-03.”

Here, the formula will return “4” because it’s extracting the month from the date “2022-04-15,” which corresponds to April.

For this date, the formula will return “1” because it’s the month of January.

As you can see, the MONTH function is a quick and efficient way to work with dates and extract the month component for various purposes in Excel.

Additional information

If you’re new to Excel or need a refresher on terms and concepts, you can check out Microsoft Excel documentation for more information and resources to help you become proficient in using Excel functions.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.