Learn How to Use Microsoft Excel MONTH Function

Microsoft Excel MONTH Function

The purpose of the MONTH function is to get a month as a number (1-12) from a date. That means the Microsoft Excel MONTH function extracts a month from a specified date to a number from 1 to 12. So, you can use the MONTH function to extract a month number from a date into a cell. You can also feed a month number into another function similar to the DATE function.

MONTH Function Return Value

It will return the value from 1 to 12.

MONTH Function Syntax

= MONTH(date)

Where:

• date: A valid Excel date.

How to Use Microsoft Excel MONTH Function?

As we know, the MONTH function extracts a month from a given date as a number between 1 to 12. You can understand this by the examples given below:

• = MONTH("17-Sep-2020") - This will return a value 9.
• = MONTH("26-Jan-2020") - This will return a value 1.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel