In this post we will see how to find/get the month name from a given number in excel.
Suppose we have 1 representing Jan, 2 representing Feb and so on.
Our objective here is to get the month’s name from a given number ranging from 1 to 12.
As you could see in the pic below, I have some numbers in column A and the corresponding month’s name in column B.
Getting month’s name from a number is very useful in excel as we perform a lot of calculation on dates like subtracting n number of days from a date, or subtracting n number of months from a date and surely we would like to get the month’s number and subsequently its name.
We will use a simple TEXT formula in excel, which is used to format any text as per our requirement.
The argument of TEXT function is TEXT(VALUE,’Format Text’).
Step 1
Enter the formula =IF(A2>12,””,TEXT(DATE(2017,A2,1),”mmmm”)) in cell B2, notice that I have put an if condition to check whether the number is greater than 12 or not, in case its greater than 12, we will just show a blank.
In The second part of the formula TEXT, you could see , I have provided the Format text as “mmmm”, which represent the month name in excel. Since we want full month name from a number in excel, we have used “mmmm”, you could also use “mmm”, if you want curtailed version of month name.
Step 2
Hit Enter
You can see, February is populated which is the month name , corresponding to the number 2.
Now drag the formula till the row you have data available.
