count totals by week and month respectively

[cutcreative]

Dear all,

sorry for probably a trivial question:

I am creating a spreadsheet converting daily values into weekly ones in the next tab and monthly values in another.

Formula for the daily ones, converting daily cash values into weekly, created by hand looks like:

=SUM('Daily Sales'!B35:B41)

Now, there's several different amounts (as forms of payment), adding up to 4 different totals. (net, taxed and so on..)

Same situation with monthly one:

=SUM('Daily'!B32:B62)

Once I would like to change to the next column (as a different payment form) it obviously goes:
=SUM('Daily'!F32:F62)

My problem is:

once I have created the weekly formulas (three rows of them) I cannot just copy and intelligently paste to all the below weeks, because excel starts counting from the next cell below, not from 7 cells down (as of 7 days in the week). Intelligent filling in doesnt work either.
Row by row it looks like:


=SUM('Daily Sales'!B35:B41) so its week 1
=SUM('Daily Sales'!B42:B48) week 2...
=SUM('Daily Sales'!B49:B55) week 3..

coming to week 4, when copied or intelligently filled by excel it starts:

=SUM('Daily Sales'!B38:B44) as of 3 cells down from the original one.

Al I want it to do is to count the cells from 1st tab in the rows of 7 as weeks and 30 or 31 as of months respectively.

can Someone please help me?

thanks in advance.