Hello Everyone, here is my problem statement.

I have certain dates spanning several years in column A.

I want to display only the Month and Year in Column B from the date mentioned in column A

Eg:
A1 has 09-Jul-13
A2 has 09-Aug-13,
A3 has 13-Feb-2014.

B1 should show Jul-13
B2 should show Aug-13
B3 should show Feb-14

I have been trying the IF forumla but have not been able to make it work. Can someone help me out with the correct IF formula or any other way by which I can achieve the above result.

Thank You