| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of last 30 days
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average for last 30 days | Excel Discussion (Misc queries) | |||
| Average days between dates | Excel Worksheet Functions | |||
| 7 previous days average | Excel Worksheet Functions | |||
| Average of days within a range | Excel Worksheet Functions | |||
| Need to Sum Mon-Sat each seven days; Average Sunday | Excel Worksheet Functions | |||
Threaded Mode
