This article explains how to use the MONTH function in Excel to extract a month number from a date and convert it to the name of the month. The instructions in this article apply to Excel for Microsoft 365, Excel 2019, Excel 2016, and Excel 2013.

The MONTH function in Excel returns a number between 1 and 12. This number corresponds to the month for the date in the selected cell or range.

The syntax of the MONTH function is: MONTH(serialnumber)

The serial number is the date you want to extract the month from. This must be a valid Excel date.