Changing date formats in excel 2013

How do I change a date such as 06/26/1987 to June-1987 in Excel. It needs to separate month into one column and year in a separate column.

So Column F on the spreadsheet reads 06/26/1997. Column O = 6 Column P =1997

Thanks

Solution 1:

In O2:

=MONTH(F2)

If you want the month in its name form then use this:

=TEXT(F2,"mmmm")

Or just:

=F2

And change the format to mmmm.

IN P2:

=YEAR(F2)