Summarize Date by Week

south0085

Board Regular
Joined
Aug 15, 2011
Messages
141
Our HR department wants me to create an easy way for them to summarize the following data:

Sheet1

ABCDE
1NameHome DeptDept Worked InDateHours Worked
2GarrettAssemblyInjection11/7/20174
3aNgelaAssemblyPaint11/1/20176
4TravisInjectionAssembly11/2/20178
5TonyPaintInjection11/10/20171
6StephaniePCPaint11/21/20178
7TammyAssemblyPC11/1/20173
8GarrettPaintAssembly10/5/20178
9aNgelaAssemblyPaint9/4/20171
10TravisPCAssembly11/10/20178
11TonyAssemblyInjection11/21/20171
12StephanieAssemblyPaint11/1/20178
13TammyAssemblyPC10/5/20171
14GarrettInjectionAssembly9/4/20178
15aNgelaAssemblyPaint11/10/20178
16TravisInjectionAssembly11/21/20171

<tbody>
</tbody>



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

ABCD
#CACACA ; text-align:center; " >25Home DeptDept Worked InHours TotalWeek
#CACACA ; text-align:center; " >26AssemblyInjection1511/6-11/11
#CACACA ; text-align:center; " >27InjectionPC2111/6-11/12
#CACACA ; text-align:center; " >28HRPaint1611/6-11/13
#CACACA ; text-align:center; " >29PaintAssembly1811/6-11/14

<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; ">
</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!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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!
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top