Excel Date Functions : MONTH

Introduction to MONTH Function

MONTH function 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.

Download Sample File

Download Sample Files to work, practice and master the Date Functions in Excel.

Syntax of MONTH Function

MONTH(serial_number)

Arguments of MONTH Function

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

Example of MONTH Function in MS Excel

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.

Other Excel Date Functions Tutorials

You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.

• DATE Function
• DATEVALUE Function
• DAY Function
• DAYS Function
• EDATE Function
• EOMONTH Function
• MONTH Function
• NETWORKDAYS Function
• NETWORKDAYS.INTL Function
• TODAY Function
• WEEKDAY Function
• WEEKNUM Function
• YEAR Function