In a spare column
and copy down. Then copy those results then Edit > Paste Special, tick Values and click OK.
Then select those results, Date > Text to Columns, click Next twice, tick Date and select MDY then click Finish.
You can then use MONTH to get the months.