I would like to create my pivot table displaying data with the date shown as
day-of-the-week. That is, I have data collected for a period of months. I
want to group my data for several months into Monday, Tuesday, etc. so I see
the results for all of the Mondays, Tuesday, etc. in the several month period.

Example: For the period Jan 1, 2004 to June 30, 2004:

Mon Tue Wed Thu Fri Sat Sun
Data1 35 20 46 58 98 109 232

Any suggestions greatly appreciated; can it be done in Pivot Tables?
Dan