Hi! I'm trying to create a calendar for my boss in Excel that calculates a weekly total, monthly total, running weekly average, running monthly average, and annual total for whatever data values he inputs in Column D (see attached example). He wants the totals/averages to update any time he adds new data, and he also wants the "dashboard" with the totals/averages to "float" when you scroll down the document. However, the calendar format he wants is very specific (again, see attached - Column C would be hidden, he wants to just see the dates as laid out in Columns A & B). Additionally, he wants weeks in this format to run Saturday - Friday. All Saturdays and Sundays in the list are highlighted in yellow (another formatting quirk he wants).

calendar example.xlsx

Anyway, I cannot figure out how to calculate the weekly total, monthly total, running weekly average, running monthly average, and annual total that he wants - especially not using the calendar format he wants. Help???

Thanks!