Stuck substring month and year in excel

Question

I would like to substring only month and year in Excel.

In example: A1=01/15/2013, result should be 01/2013

How to do that in Excel?

Regards,

Answer 1

perhaps simply

=TEXT(A1,"MM/YYYY")

Answer 2

This can be done using excel OOTB utility. Look at the Sample

Refer image attached:

Answer 3

This should do it:

=TEXT(MONTH(A1),"00")&"/"&TEXT(YEAR(A1),"00")