Hi, I have a monthly report like below showing daily scores, I'd like to know if there is a vba I can use to sum the weekly total every month. So basically the total of week 1, week 2...week 5.

Date Score
4/1/2012 2115
4/2/2012 2492
4/3/2012 2421
4/4/2012 2297
4/5/2012 2148
4/6/2012 2037
4/7/2012 3560
.
.
.
4/28/2012 2340
4/29/2012 2188
4/30/2012 2075