I'm new at this so be kind please.
I have a spreadsheet that has five columns. The data in the columns is based
on a persons name and changes with each person selected from a drop down
list.
One column list the numbers of hours worked on a workorder in a second
column.
a third column has the dat the hours were worked.
I can get this for the entire year.
What i want is to be able to total the hours in a given week of the year.
I used the Conditional Sum Wizard and it works great with exact dates and
times but will not work with a range of dates.

With me so far?