You could put in a few hidden columns next to the dates,
using

=month(date cell)
=year(date cell)

this will show for example

=month(c1), with c1 being "01/05/04", will show a result
of 5. You can then have these in your pivot table
selection. You could even run a vlookup using the month
result against it's actual month name

1 January
2 February

=vlookup(month(date cell),(lookup table range),2,0)

Hope this helps

Nath.
-----Original Message-----
I have hundreds rows of data with different record dates
and want to
summarise data by month/year.
But the pivot table returns records by day/month/year.


Pls help.


.