Change Date Values

[Guest]

Greetings,
I've created a pivot table that has dates along the top and quantities sumed
in the data field. The problem is that Excel is not combining the date like
I want. I want the date columns at the top to be distince my month-year, but
excel is distinct for full date. To give an example. I have columns for
January 2004 such as this:

01/01/04 01/02/04 01/03/04

I want a single column for January 2004 with quantities added together and
not seperated by the day. Please help. Thank you.
Rod Neville

 

[Dave Peterson]

Select one of those headers and right click on it.
Choose Group and show detail
Group by month (and probably years???).