Here is my scenario:

Column A of my worksheet contains data in A1:A364 (representing daily values
for one year)
I want Column B to contain weekly averages, i.e. B1=average(A1:A7).
When I copy the formula to B2, Excel makes the formula B2=average(A2:A8).

Is there a way for me to be able to copy the formula such that I get the
correct results, B2=average(A8:A14), B3=average(A15:A21) ...
B52=average(A358:A364)?

Thanks in advance for any assistance provided.