Aggregate (sum) daily data to weekly data

[Ivanwinpa]

Hi Folks. I have daily transaction data that i would like to aggregate to weekly data. The count for week should start from the first day of the data. For instance, if the data date starts on 13-Jan-2022, the end of the week should be t+7 i.e 19-Jan-2022 and that should be categorized as week 1. How can i possibly aggregate this?SampleData2.csv

[Glenn Kennedy]

G2:
=A2

G3, copied down:
=A2+7

H3, copied down:
=SUMIFS(B:B,A:A,">="&G2,A:A,"<"&G2+7)

[Czeslaw]

If only so with Power Query

Please Login or Register  to view this content.

[Ivanwinpa]

Thanks Glenn. This was very helpful

[Ivanwinpa]

I will explore this as well. Thanks

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.