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.