The Syntax of the MONTH Function
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(serial_number) The serial_number is the date from which you want to extract the month and must be a valid Excel date.
How to Use Excel to Get a Month From a Date
When your Excel worksheet contains a column of dates that are in a date format that Excel recognizes, use the MONTH function to extract the serial number for the month and place the serial number in a separate column. The Excel MONTH function extracts the month from a list of dates. The month displays as a serial number between 1 and 12. If you want to convert this number to text, create a named range.
How to Convert a Month Number to Text
There’s a two-step process to convert the serial number for a month to the text name. First, create a named range, then use the named range to convert the serial number to text.
Create a Named Range
The first step to convert a serial number to a month’s name is to create a range. This range contains the number and the corresponding month.
Convert the Number to Text
The next step is to select the column where you want to insert the text version of the month.
