How do you  return the month name in excel?
 If you only want to display a month name, you don't need a formula – you can use a custom number format. Select the date and navigate to Format cells (Ctrl + 1 or Cmd +1), then select Custom and enter one of these custom formats: mmm // Jan mmmm // January. 