Counting by weeks

[samwignall]

Hi all,

Table 1 looks similar to this:

..............................Saturday 1 Jan | Sunday 2 Jan | Monday 3 Jan | Tuesday 4 Jan | Wednesday 5 Jan | Thursday 6 Jan | Friday 7 Jan
Row 1............................1......................1......................1......................3.........................4...........................4.....................1
Row 2............................1......................1......................2......................1.........................7...........................4.....................2
Row 3............................1......................1......................3......................3.........................2...........................4.....................8


The columns run for the entire year!
So i want to break down into weeks in a seperate table.

For example I could do =Sum(B2:H2) for Week 1 and I2:O2 for Week 2
However I need to do this for 52 weeks! How can I automate this?


Thank you!