On Fri, 8 Feb 2013 16:43:58 +0000, AuditorLisa wrote:


I have the below list of days, and numbers corresponding to each day. I
am trying to group the dates into weeks, with a total number for each
week instead of each day. Is there any way to accomplish this?

03-Jan-12 Count 168
04-Jan-12 Count 193
05-Jan-12 Count 175
06-Jan-12 Count 101
09-Jan-12 Count 119
10-Jan-12 Count 64
11-Jan-12 Count 82
12-Jan-12 Count 68
13-Jan-12 Count 45
16-Jan-12 Count 115
17-Jan-12 Count 33

You could use a pivot table.

Put headers in the row above your data (e.g. Dates | Counts)

Insert/Pivot table.

Drag dates to the row labels area
Drag Counts to the Values area.

Right click on some date and select "group"
Group by days and select '7' for the number of days.
Format to taste

--------------------
Row Labels Sum of Count
1/3/2012 - 1/9/2012 756
1/10/2012 - 1/16/2012 374
1/17/2012 - 1/18/2012 33
Grand Total 1163