How to Extract Month from Date in Excel (5 Quick Ways)

The following dataset contains some Product IDs, Sales, and Dates in columns B, C, and D. We want to extract the months from the Date column.

Method 1 – Using Custom Formatting to Extract the Month from a Date

STEPS:

Select the date column from where you need to extract the month.
Right-click and select Format Cells. This will open the Format Cells dialog box.

From the Number menu, go to Custom and type “mmmm”.
Click OK.

The selected cells will now only show the months.

Method 2 – Getting the Month from a Date with the TEXT Function

We’ll get the result in a separate column E.

STEPS:

Select cell E5.
Insert the following formula:

=TEXT(D5,"mmmm")

Drag the Fill Handle over the range E6:E10.

We can see the result which shows only the months in column E.

Method 3 – Applying the CHOOSE Function to Extract the Month from a Date in Excel

As in the previous method, we will get the result in another column E.

STEPS:

Select cell E5 and insert the formula below, then hit Enter.

=CHOOSE(MONTH(D5),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

The MONTH function will retrieve the month number from the date. CHOOSE then returns the corresponding value from the array list.

Drag the Fill Handle down.

Here are the results.

Method 4 – Utilizing the SWITCH Function to Get the Month from a Date

We are using the same dataset as before.

STEPS:

Select the cell where we want the result. We selected cell E5.
Insert the following formula:

=SWITCH(MONTH(D5),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,July",8,"August",9,"September",10,"October",11,"November",12,"December")