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

July 22, 2022
33.8K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

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. To get these details and other information about a particular month as shown in cells, follow these steps:

Tips that are provided in this article are compatible with versions 2010/2013/2016.

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 NO)

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, ’ldquo;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? You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS office to edit the word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.