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’).
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.
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.