Trying to Create a Calendar with Daily and Weekly Data Totals Directly from a Pivot Table

If you have a 30-day month that starts on a Saturday, or a 31-day month starting on either a Friday or a Saturday, then this will occupy 6 weeks with the Sunday to Saturday layout, so your calendar needs to take account of this.

I've set this up in the attached file - the start date is taken from whatever is displayed in cell A5, so if you adjust your filter in A4 then the calendar will also automatically adjust (as will the title).

Hope this helps.

Pete