C
Cari
Hello,
I hope someone can help me. I have a formula that I need
to create and I'm stumped on how to do it. This is a
spreadsheet that shows a log of how many items our
Engineering department has jobs / quotes to process. Each
job is on it's own row showing the date it is due and how
many hours it's needed to complete this job / quote. We
need to see how many hours per week (we look at 6 weeks
worth continuously) and total jobs/quotes in that week. I
cannot figure how to calculate date range example week of
10/10/03 the spreadsheet looks like this:
Date Due Hours
10/06/03 3.00
10/07/03 3.00
10/08/03 2.50
10/10/03 3.00
Below the log entry, I have totals that I total up
manually to show this:
For the week of: Total Hours
10/03/03 15.00
10/10/03 25.00
10/17/03 20.00
Does anyone know what the formula is to do this without
doing manually? Thanks so much for your assistance in
this matter.
Sincerely,
Cari
I hope someone can help me. I have a formula that I need
to create and I'm stumped on how to do it. This is a
spreadsheet that shows a log of how many items our
Engineering department has jobs / quotes to process. Each
job is on it's own row showing the date it is due and how
many hours it's needed to complete this job / quote. We
need to see how many hours per week (we look at 6 weeks
worth continuously) and total jobs/quotes in that week. I
cannot figure how to calculate date range example week of
10/10/03 the spreadsheet looks like this:
Date Due Hours
10/06/03 3.00
10/07/03 3.00
10/08/03 2.50
10/10/03 3.00
Below the log entry, I have totals that I total up
manually to show this:
For the week of: Total Hours
10/03/03 15.00
10/10/03 25.00
10/17/03 20.00
Does anyone know what the formula is to do this without
doing manually? Thanks so much for your assistance in
this matter.
Sincerely,
Cari