# Daily Totals every week?

1. ## Daily Totals every week?

Hello,

Is it possible to get a daily ongoing total of daily values that re-starts every week? I'm using WEEKDAY() to count the days, but don't know how to SUM from the start of the week to the current (row) day/date.

Just trying to get an accumulation of hours (decimal) per week as follows

eg: (3 columns)
01/10/2021 = 5.0 = Total = 5.0
02/10/2021 = 5.5 = Total =10.5
03/10/2021 = 4.0 = Total =14.5
04/10/2021 = 8.0 = Total =22.5
05/10/2021 = 4.5 = Total =27.0
06/10/2021 = 9.5 = Total =36.5
07/10/2021 = 4.5 = Total = 41.0
08/10/2021 = 2.0 = Total = 2.0
09/10/2021 = 3.0 = Total = 5.0
10/10/2021 = 2.0 = Total = 7.0
11/10/2021 = 1.0 = Total = 8.0
12/10/2021 = 4.5 = Total = 12.5
13/10/2021 = 2.0 = Total = 14.5
14/10/2021 = 9.0 = Total = 23.5
15/10/2021 = 1.0 = Total = 1.0
16/10/2021 = 5.0 = Total = 6.0
...etc..

Without using arrays/shift-enter, etc.

The dates are not specific, and summing from the start of the week and SUM expands on each row by +1 row more.....

2. ## Re: Daily Totals every week?

There are instructions at the top of the page explaining how to attach your sample workbook.

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. Thanks.

4. ## Re: Daily Totals every week?

I answered it myself by using offset.

its a shame this forum has turned into a rules forum and simple questions cannot be posted without 'attachments' which can pose risks....this forum use to be decent.

Mod: please delete this post, I wont be returning. thanks

5. ## Re: Daily Totals every week?

your week stops on thursday ?
``Please Login or Register  to view this content.``

6. ## Re: Daily Totals every week?

@q_lander

Alan

There are currently 1 users browsing this thread. (0 members and 1 guests)