Formula and dates

[StevenAFC]

Hi im trying to do something that I though would be pretty simple, but
is complicated by the way excel handles dates.

In a column I have formatted Dates like this...

12/05/04
13/02/05
18/02/05
14/08/05

etc

In the column along side I simple want...

0504
0205
0205
0805

Previously Ive just used a format to change it to MMYY, however when
that is put into a pivot table, the pivot table seperates the same
data, and it still recognises the entire date.

So in the pivot table I end up with duplicates.

Ive tried using the following code

=IF(A2="","",MID(A2,3,2))

To retrieve the date, but all I get is the raw number excel uses to
store dates IE 38777, instead of 01/03/06, therefore ending up with 77
and not 03.

I hope I havent over complicated this questions, all I need is the
month and the year!

 

[daddylonglegs]

Try

=TEXT(A2,"mmyy")

 

[StevenAFC]

Perfect thanks alo