Summarize Date by Week

[south0085]

Our HR department wants me to create an easy way for them to summarize the following data:

Sheet1

[TABLE="class: cms_table"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Name[/TD]
[TD]Home Dept[/TD]
[TD]Dept Worked In[/TD]
[TD="align: left"]Date[/TD]
[TD]Hours Worked[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Garrett[/TD]
[TD]Assembly[/TD]
[TD]Injection[/TD]
[TD="align: left"]11/7/2017[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]aNgela[/TD]
[TD]Assembly[/TD]
[TD]Paint[/TD]
[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Travis[/TD]
[TD]Injection[/TD]
[TD]Assembly[/TD]
[TD="align: left"]11/2/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Tony[/TD]
[TD]Paint[/TD]
[TD]Injection[/TD]
[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Stephanie[/TD]
[TD]PC[/TD]
[TD]Paint[/TD]
[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Tammy[/TD]
[TD]Assembly[/TD]
[TD]PC[/TD]
[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Garrett[/TD]
[TD]Paint[/TD]
[TD]Assembly[/TD]
[TD="align: left"]10/5/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]aNgela[/TD]
[TD]Assembly[/TD]
[TD]Paint[/TD]
[TD="align: left"]9/4/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Travis[/TD]
[TD]PC[/TD]
[TD]Assembly[/TD]
[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Tony[/TD]
[TD]Assembly[/TD]
[TD]Injection[/TD]
[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]Stephanie[/TD]
[TD]Assembly[/TD]
[TD]Paint[/TD]
[TD="align: left"]11/1/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD]Tammy[/TD]
[TD]Assembly[/TD]
[TD]PC[/TD]
[TD="align: left"]10/5/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD]Garrett[/TD]
[TD]Injection[/TD]
[TD]Assembly[/TD]
[TD="align: left"]9/4/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD]aNgela[/TD]
[TD]Assembly[/TD]
[TD]Paint[/TD]
[TD="align: left"]11/10/2017[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD]Travis[/TD]
[TD]Injection[/TD]
[TD]Assembly[/TD]
[TD="align: left"]11/21/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]



Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

They want to be able to summarize it by week. (Monday thru Saturday)

A summary would look like this:

Sheet1

	A	B	C	D
#CACACA ; text-align:center; " >25	Home Dept	Dept Worked In	Hours Total
#CACACA ; text-align:center; " >26	Assembly	Injection
#CACACA ; text-align:center; " >27	Injection	PC
#CACACA ; text-align:center; " >28	HR	Paint
#CACACA ; text-align:center; " >29	Paint	Assembly

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 138px;"><col style="width: 138px;"><col style="width: 109px;"><col style="width: 74px;"></colgroup><tbody> #CACACA ; text-align:center; font-weight:bold; font-size:8pt; ">
[TD="align: left"]Week[/TD]

[TD="align: right"]15[/TD]
[TD="align: left"]11/6-11/11[/TD]

[TD="align: right"]21[/TD]
[TD="align: left"]11/6-11/12[/TD]

[TD="align: right"]16[/TD]
[TD="align: left"]11/6-11/13[/TD]

[TD="align: right"]18[/TD]
[TD="align: left"]11/6-11/14[/TD]

</tbody>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


This is completely just an example. I didn't even add up the numbers correct. I just made something up. But you get what I'm trying to do. But they want the ability to choose any week of the year. Week#1, Week#2, Week#34, etc.

Is there an easy way to do this. Keep in mind that the person using this sheet may be a novice excel user.

Thank you!

 

[south0085]

bump

 

[estevaoba]

I've been playing with this and come up with something that may be what you're trying to achieve.

As there would be too many instructions to post here, I decided to make my workbook available from the link below.

https://we.tl/jKgZtS75z4

I use helper columns N thru Q. They can be hidden.
Columns G, H, I and K are data validation from those helper columns, so users will be able to select data sets for those four columns as they please.

Good luck!