This number corresponds to the month for the date in the selected cell or range.
The date must be properly entered with theDATE functionin Excel.
grab the cell that will display the serial number for the month.
Go to the Formula bar and enter=month.
As you pop in, Excel suggests a function.
grab the cell containing the date from which you want to extract the serial number for the month.
For example, grab the first cell in a column of dates.
Enter a closing parenthesis, then pressEnter.
The result appears in the selected cell.
The serial numbers for the dates display in the highlighted cells.
The Excel MONTH function extracts the month from a list of dates.
The month displays as aserial numberbetween 1 and 12.
If you want to convert this number to text, create a named range.
First, create anamed range, then use the named range to convert the serial number to text.
This range contains the number and the corresponding month.
The data for the named range can be on the same worksheet or on another worksheet in the workbook.
Select a cell, enter a1, then pressEnterto go to the cell below.
Drag the fill handle until the number12displays next to the Fill handle.
pick the cell to the right of the number 1 and enterJanuary.
Or, enter the format you want for the month.
For example, useJanfor January.
Drag the fill handle down until the wordDecemberdisplays next to the Fill Handle.
choose the serial number and month name cells.
Go to the Name Box and enter a name for the range.
PressEnterto create the named range.
grab the cell next to the first serial number in the column.
As you pop in, Excel suggests possible functions.
go for the first serial number in the column, then enter a comma.
Enter the named range, then enter a comma.
opt for month and drag the Fill Handle to the bottom of the column.
The month names appear in the column.
