Tatsukeuyh

You need to specify a custom name for all the 12 months in the function and need to use the month function to get month number from the date =CHOOSE(MONTH(A1),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")21/2/ Suppose, you have a list of numbers (1 through 12) in your Excel worksheet that you want to convert to month names To do this, you can use any of the following formulas To return an abbreviated month name (Jan Dec) =TEXT(*28, "mmm") =TEXT(DATE(15, , 1), "mmm") To return a full month name (January December) =TEXT(*28, "mmmm")How to use MONTH function in Excel 16 This is a great video if you or someone you know wants to learn how to use the MONTH function in Excel Excel Month Function Month Name From Date Last Day Of Month Etc Month name excel formula