Method 1 (TEXT Function):

Here values from which Name of the Month is to be extracted are in range C5:C9. If we wish to extract the name of the month using function, the below function will be used:

Function: TEXT(Value, FormatText)

Here the date or the address/reference of cell where the date is stored will be used as first parameter of the function. Second parameter will be used to specify the format of the output. Don’t forget to place format into parenthesis.

Example 1: =TEXT(C5, “mmmm”)
Example 2: =TEXT(C5, “mmm”)

The output of Example 1 will be November and output of Example 2 will be Nov. If you wish output to be only 3 letter of the month name, use “mmm” whereas if you wish output to be full name of the month use “mmmm” instead.

Method 2 (CHOOSE Function):

The Excel CHOOSE function returns a value from a list using a given position or index. For example, =CHOOSE(2,”Mango”,”Banana”,”Grapes”) returns “Banana”, since Banana is the 2nd value listed after the index number. The values provided to CHOOSE can include references.

The values provided to CHOOSE can be hard-coded constants or cell references. The first argument for the CHOOSE function is index_num. This is a number that refers to subsequent values by index or position. The next arguments, value1, value2, value3, etc. are the values from which to choose from.  CHOOSE can handle up to 254 values. However, CHOOSE will not retrieve an item from inside range or array constant provided as a value. 

Usage of CHOOSE for our purpose will be as below:

Example: =CHOOSE(MONTH(C5),”Jan”,”Feb”,”Mar”,”Apr”,”May”,”Jun”,”Jul”,”Aug”,”Sep”,”Oct”,”Nov”,”Dec”)

The output of above function in our case will be:

Output: Nov