Select a blank cell, type one of below formulas to it, and press Enter key to get the month name If you need, drag the Auto fill handle to over cells which need to apply this formula =IF (MONTH (A1)=1,"January",IF (MONTH (A1)=2,"February",IF (MONTH (A1)=3,"March",IF (MONTH (A1)=4,"April",IF (MONTH (A1)=5,"May",IF (MONTH (A1)=6,"June",In cell B2 = MONTH (DATEVALUE (&"1")) The DateValue formula will convert the Month say Jan to If we format the number to Date Format, it will return 1/1/14 Enclosing the Date value formula for the Month Formula will convert the number to 1Name – It specifies the input names from your worksheet;
![Convert Number To Month Name Excel Vba Convert Number To Month Name Excel Vba](https://www.exceldome.com/wp-content/uploads/2018/07/Convert-number-to-month-name.png)
Convert Number To Month Name Excel Vba