Calling all computer nerds!

I'm stuck on a project (using completely Excel). I am rolling daily data into weekly data into monthly data. I have the first two accomplished.... Is there a formula I can create to save my week one data and start over into week two? Cause the daily with sum and store in two charts and the monthly is the sum of the four weeks....argh! Wish I had a better way to explain my dilemma.