I have a spreadsheet where numbers are entered or calculated in columns
representing each day of the year. The column headers are 1/1/05 1/2/05
etc. The second row in each column returns the appropriate day of the
week: Mon Tue Wed, etc corresponding to the date. Then numbers or
calculations returning numbers in each row thereafter.

10/31/05 11/1/05 11/2/05 11/3/05 11/4/05 etc.
Mon Tue Wed Thu Fri
5 3 5 0 1

I then need to create a report that creates two columns, one with the
total (or average) of the Monday through Saturday numbers and one for
the Sunday numbers. In other words a Daily calculation and a Sunday
calculation. How would I create this report which goes to the daily
worksheet and grabs the Mon-Sat numbers for week 1, the Sunday number
for week 1, then goes to week 2, week 3, etc.