Ruth,

I'm still confused. You want an average of the last 7 days so why do we
look back 30 days? Let's assume your data are in column A starting in A2.
isn't it as simple as putting this in B8 and dragging down each day to get
the last 7 days

=AVERAGE(A2:A8)

so when you enter data in A9 and drag the formula down it becomes

=AVERAGE(A3:A9)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Ruth" wrote:

Hi
I update a spreadsheet daily with my forecasted calls vs actual calls, I
would like to keep a rolling average for the 7 days of the week that looks
back over the last 30 days of information. So it would be set out as below:

Day Average
Saturday ##
Sunday ##
Monday ##
Tuesday ##
Wednesday ##
Thursday ##
Friday ##

Any help would be greatly appreciated
--
Thanks

Ruth