Assume you have numbers to average in row 1, beginning at column 1 and going
across the sheet. At G2, enter this formula:
=AVERAGE(A1:G1)
and simply extend the formula to the right, it will automatically give the
average of the value above it and in the 6 cells to the right of that cell,
sliding as it goes.

Hope this helps.

"p-nut" wrote:

I am trying to set up a 7 day moving average and cannot figure out how to set
it up? Any help would be great.