how to get week day wise, date wise value from raw data

[emmr]

Hello everyone,
i have a raw data from 1-july-20 to 31-july-20
how i can get the value as per below requirement
1. sum of all week day, like sunday, monday tuesday etc
2. show value from suday to saturday
3. show value from 1-july-20 to 07-july-20, click a option to change & show from 8-july-20 to 14-july-20 & so on

attached sample file for your convenience, exception your cooperation.

thanks in advance for your nice cooperation.

thanks again

[alansidman]

Not exactly sure of what your desired output should look like. Would have been nice if you provided a mock up. Here is my best guess. If this works then advise and I will show you how.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H
1	Week of Year	Week Totals
2	27	950
3	28	2056
4	29	2039
5	30	1911
6	31	1926
7
8
9	Week Nr.	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
10	27				234	311	198	207
11	28	374	398	268	287	266	214	249
12	29	288	327	340	326	326	203	229
13	30	327	247	235	303	312	163	324
14	31	361	354	393	363	455

Sheet: Sheet1

[emmr]

Dear alansidman, its really owo, it will help me, if i get the sum of sunday, monday etc thats will be enough, can you plz show me how i can do this,
thanks a again, thanks a lot

[alansidman]

I don't know what "owo" means. As to how I got the weekly totals by Day of the Week. I used Power Query. Here is the Mcode

Please Login or Register  to view this content.

Power Query is part of Excel beginning with 2016. It can be downloaded as an add in from MS for your 2010 version.

Review PQ
In the attached file in my earlier post
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

[emmr]

thanks a lot, but is there have any other way, except macro?

[alansidman]

This is not a Macro. That would be VBA or Visual Basic Application. This is Power Query. Click on the link in my signature block to learn more about it. There may be other ways, but not with my skill set.