The MONTH function returns with a month number from 1 to 12.
where (serial_number) is a valid date in Excel format.
Copy and paste the formula in other cells.
If you enter the date in text format or in an unrecognized format, Excel will show the #VALUE! error.
Get month name from date
You may also get month name by using TEXT function.