Hi

I have list of data with various dates.

Example 06/01/08 item1
07/01/08 item2

What I want is another column which displays just the month and year.
However it is going to be used in a pivot table so the actual day information
needs to be lost so I can filter on it (if I change the format to month and
year info is hidden but still there so displays as many dates in the pivot
table).

Hope this makes sense, in short I need to remove the day information
completely and have just the date and year.

Any greatly appreciated

Kind regards

Rexmann