I'm facing a similar problem, and Jon, I find a pivot table to get me
very close to where I want to be, except that, like Sean, I have a
dates field that looks like this:

1/12/06 10:20 AM
1/12/06 11:44 AM

So two entries for January 12th, but different times. Now I can format
the cells to show only the dates, but when I use a pivot chart, it sees
both those rows as different, and will create a total of 1 for 10:20 am
and one for 11:44 am. How do I get the pivot chart to ignore the time
and only pay attention to the date?