Get month and year from date cells Excel

Question

I want to isolate month and year from a date column, but this column has two formats:

08 May 2011 00:59 and 08-05-2011.

If I want to have a new column to isolate month and year from this column like: 05-2011, how should I do that?

Answer 1

The steps to modify the date format to simply get the month and year using the TEXT function are as follows:
1.Click in a blank cell where you wish to see the new date format (B2)
2.Insert the following formula: =TEXT(A2,"m/yy")
3.Press the Return key on your keyboard.
4.This should show the original date in the format we need.