Not exactly sure what you mean. If your weekly data starts in A1 and
goes to A40, enter this formula in cell B1 then copy down. Note the
absolute references on one half of the formula.

B1 =Average($A$1:A1)

- John