How to get month name from a date in Excel (3 easy ways)

July 22, 2022
59.9K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

Catalog

How to Get Month Name in Excel from a Date in Excel: Cell formatting Method
How to Get Month Name from a Date in Excel: Using Month Function
How to Get Month Name from a Date in Excel : Using Text function
Did You Learn about How to Get Month Name from a Date in Excel?

It's a rare occasion when you'll find yourself in a situation where you need to get the month name from a date in Excel. Most of the time, people go on Google to find this kind of information. Month names is important in Excel. Knowing how to get the month name from the date in your worksheet is necessary because there are many tools that need the month name.

In this post, we will discuss how to get the month name from the date in Excel. Year, month, and day can be displayed on Microsoft Excel in the sheet tabs. You can also set the date format for each record by selecting appropriate date information through the drop-down list. 

The following steps will be provided by WPS Office, a free office suite that is fully compatible with all Microsoft Office files, so if you are looking for a free alternative to Microsoft, WPS Office is a more suitable choice.

How to Get Month Name in Excel from a Date in Excel: Cell formatting Method

If you are someone who don;t like putting up long functions in the formula bar and wait for all those errors that you can’t mix then this method is for you , all you need is to change the format of your date and boom that‘’s it your job is done.

1. Select the date , left click on that cell.

2.And select the format cell.

3.Select the custom option.

4.And type mmmm

5.This will convert the date into the respective month.

How to Get Month Name from a Date in Excel: Using Month Function

If you find the above method a little hard for you then you use a simple formula for conversion of date into the month. The month formula in Excel is used to calculate the number of months between two dates.

You can use this formula to calculate how many months there are between two dates by simply entering the first date in cell A1, and then entering the second date in cell B1. The formula will return a single number, which represents the number of months between these two dates. 


The formula is MONTH(Cell Number).


The monthly formula in Excel is a very useful tool. It can help you calculate a variety of financial data and to do that accurately and quickly It is quite useful when you want to change a number of your dates into the month format for further calculations It returns the  number of month instead of that name (Jan(1) to December (12))

1.Select the cell with date inside it

2.Use the formula.

3.This will convert your date into the respective month like we can see ,here it’s converted to the 9th month

How to Get Month Name from a Date in Excel : Using Text function

Text function is another way to convert your date into the month ,the syntax of this function is

Text(Cell Number, "mmm")

1.Here’s how to use this function to get month name, select the cell and write this formula.

2.You can see we have got our required month in the respective selected cell

Did You Learn about How to Get Month Name from a Date in Excel? 

This is how the MONTH function in Excel works. As you already know, WPS Office provides 3 ways to get month name from a date in Excel at least,  there are 

  1. Using Cell formatting Method

  2. Using Month Function

  3. Using Text function

If you want to learn more about useful features of Word documents, Excel Spreadsheets, and PowerPoint slides,  You can follow WPS academy.

If you are interested to edit Word documents, Excel Spreadsheets, and PowerPoint for free, You can also download WPS Office.