Example Convert number to month name METHOD 1 Convert number to month name EXCEL = TEXT ( DATE (17,B5,1),"mmmm") The formula returns the month's name that is related to the specified number, between 1 and 12 We have manually inserted the first day of a month and any year, in this case using 17To get the month name (ie January, February, March, etc) from a date as text, you can use the TEXT function with a custom number format In the example shown, the formula in cell C5, copied down, is = TEXT(B4,"mmmm") As the formula is copied down, the TEXT function extracts a month name from each date in column BExcel MONTH function Excel Details How to extract month name from date in Excel In case you want to get a month name rather than a number, you use the TEXT function again, but with a different date code =TEXT (, "mmm") returns an abbreviated month name, as Jan Dec =TEXT (,"mmmm") returns a full month name, as January December convert number to month name excel
1
