Excel MONTH Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel MONTH Function (Example + Sample File)

What is EXCEL MONTH FUNCTION

The Excel MONTH Function is listed under Microsoft Excel's Date Functions category. It returns the month number (ranging from 0 to 12) from a valid date. As you know, in Excel, a date is a combination of day, month, and year, MONTH gets the month from the date and ignores the rest of the part.

How to use it

To learn how to use the MONTH function in Excel, you need to understand its syntax and arguments:

Syntax

MONTH(serial_number)

Arguments

  • serial_number: A valid date from which you want to get the month number.

Notes

  • The date from which you want to get the month number should be valid.
  • If you mention an invalid date it will return #VALUE! Error.
  • If you skip entering any value in serial_number it will return 0.

Example

To master the MONTH function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used a MONTH in three different ways:

  • In the FIRST example, we have simply used date and it has returned the 5 in the result which is the month number of MAY.
  • In the SECOND example, we have supplied the date directly in the function.
  • In the THIRD example, we have used the TODAY function to get the current date and MONTH has returned the month number from it.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.