Average of last 30 days
You need to provide more information -- where is the data (how is it laid
out), and what form are your dates in? Are they true Excel dates, or the
words "Saturday", etc.
Regards,
Fred
"Ruth" wrote in message
...
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
|