I'm trying to do the following:

a) Have one column show the date of each Saturday (starting 1/18/09) in each row, for example, 1/18/09, then 1/25/09, then 2/1/09, etc.

b) Have each other column show the corresponding averages for the week prior(referencing data in another sheet)--how do I set it up to only calculate the average for each week in each row, for example, average(B1:B7), then next row =average(B8:B15).


Thanks for your help guys!