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

In Excel, we can do a lot of things with our spreadsheet. We can put the dates in our spreadsheet and extract days, months, years from the dates. In this article, we will see different ways to extract the month from date in excel.


Download Practice Workbook

You can download the workbook and practice with them.


5 Ways to Extract Month from Date in Excel

We can extract a month from a given date in many ways. To do this, we are going to use the dataset below. The following dataset contains some Product IDs, Sales, and Date severally in columns B, C, D. Now we want to extract the months from the Date column. So, let’s demonstrate the ways to extract the month from the date.

5 Ways to Extract Month from Date in Excel


1. Custom Formatting to Bring out Month From Date

To extract the month from a date, we can change the date format using custom formatting. For this, we need to go along with the steps below.

STEPS:

  • First, select the date column from where we need to extract the month.
  • Then, just right-click and select Format Cells. This will open up the Format Cells dialog box.

Custom Formatting to Bring out Month From Date

  • Next, from the Number menu, go to Custom and type “mmmm”. Then click OK.

Custom Formatting to Bring out Month From Date

  • Finally, the selected cell will now only show the months.

Read More: How to Extract Year from Date in Excel (3 Ways)


2. Withdraw Month From Date Using TEXT Function

There are some built-in functions in excel. With those functions, we can perform varieties of activities. Excel TEXT function is one of the useful functions. By this function, we can extract the months of dates. In the same token, we are using the following dataset. But now we will see the result in another column E. So, let’s take a view of the steps down.

Withdraw Month From Date Using TEXT Function

STEPS:

  • In the first place, select cell E5. And, write down the formula below.
=TEXT(D5,"mmmm")

Withdraw Month From Date Using TEXT Function

As we take the date from D5, so after writing ‘=TEXT’ select the cell D5 where we want to take the date from. Then just put down “mmmm” to show the month.

  • Next, drag the Fill Handle over the range E6:E10.

Withdraw Month From Date Using TEXT Function

  • In the end, we can see the result which shows only the month in column E.

Read More: How to Extract Data from Excel Based on Criteria (5 Ways)


3. CHOOSE Function to Extract Month From Date in Excel

The CHOOSE function will also help to withdraw the month from a date. Again we use the same dataset. As shown in the previous method, we will see the result in another column E. We name the column month as we want to see only months in that column. We also need the MONTH function to take the number of months. The steps to extract the month from the date column are given below.

CHOOSE Function to Extract Month From Date in Excel

STEPS:

  • In the beginning, select cell E5 and write down the formula below, and hit Enter.
=CHOOSE(MONTH(D5),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

CHOOSE Function to Extract Month From Date in Excel

The MONTH function will help us to take the month number from a date. So, we put the MONTH function inside the CHOOSE function and sequentially write the short month name.

  • Now, likewise, the previous method, drag the Fill Handle down.

CHOOSE Function to Extract Month From Date in Excel

  • As a result, now, we can view the short month name in the Month column.

CHOOSE Function to Extract Month From Date in Excel

Read More: How to Extract Data From Table Based on Multiple Criteria in Excel


Similar Readings


4. Excel SWITCH Function to Pull Out the Month from Date

Another function to extract a month from a date is the SWITCH function. We can get the number of the month with the MONTH function. After that, we will switch the month name by the month numbers. So, let’s take a view of the steps.

We are using the same dataset as before.

Excel SWITCH Function to Pull Out the Month from Date

STEPS:

  • First, select the cell where we want the result. So, we select cell E5.
  • Next, write down the formula below.
=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")
  • Press Enter.

Excel SWITCH Function to Pull Out the Month from Date

The formula we use the MONTH(D5) which is inside the SWITCH function will give the number of months. Then, it will swap the numbers of the months to the names of the months.

  • Further, drag the Fill Handle down.

Excel SWITCH Function to Pull Out the Month from Date

  • And, finally, we can view the result in the month column.

Excel SWITCH Function to Pull Out the Month from Date

Read More: How to Pull Data From Another Sheet Based on Criteria in Excel


5. Using Power Query to Extract Month from Date

If we need to extract the months from a date, the power query is another way to do this. Let’s demonstrate how we use the power query to extract the months from the date.

STEPS:

  • First, select the whole dataset. Then, go to the Data tab on the ribbon.
  • Second, from the Data tab menu, go to From Table/Range.

  • This will appear in the Create Table dialog box.
  • Next, click on the OK button.

Using Power Query to Extract Month from Date

  • This will open up the Power Query Editor.

Using Power Query to Extract Month from Date

  • Now, we want to extract the month from the date column. So, we select the date column and right-click.
  • Next, go to Transform.
  • Then, put the mouse on Month.
  • After that, click on Name of Month.

  • On the other hand, we can also use the formula below.
= Table.TransformColumns(#"Changed Type", {{"Date", each Date.MonthName(_), type text}})

The above formula will take the month name from each date.

  • Finally, press Enter. And, we can now view our desired result.

Read More: How to Extract Specific Data from a Cell in Excel (3 Examples)


Conclusion

The above examples assist you to extract the month from the date in Excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo