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…