I have data such as:
05/10/07 May-07 72,045.00
06/11/07 June-07 27,000.00
06/11/07 June-07 98,468.25
06/28/07 June-07 28,778.80
06/28/07 June-07 92,722.80
07/10/07 July-07 3.79
The first column is the actual date and the second column is the same date
but just formatted different and the third column is cost.

I want to consolidate all cost by month via a pivot table and I have setup
the pivot table but it shows multiple costs for the same month. If I round
the dates in the middle column to the first of the month that they occur, my
pivot table should work.

How can I accomplish this or is there a better way to accomplish my task?

Any help is appreciated, Thanks.