√100以上 excel month name from number 786119-Excel formula get month name from number
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 1 To return the name of the month =TEXT (DATE (B1,1,A1*72)WEEKDAY (DATE (B1,1,3)),"mmmm")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 17 How To Convert Month Name To Number In Excel Excel formula get month name from number