# 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.....  Register To Reply

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.  Register To Reply

3. ## Re: Daily Totals every week?  Register To Reply

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  Register To Reply

5. ## Re: Daily Totals every week?

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

6. ## Re: Daily Totals every week?

@q_lander

Alan  Register To Reply

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