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 alot