Trouble with dates......
 

I do not know any VB but I have experience with C and Java. I have data
sets on a worksheet that are from different days, which are then
orgranized into one worksheet per week. Can anyone explain how I could
make a form inside a work sheet that would allow me to enter in a pair
of dates to display a particualr summation of the data set in a graph
depending on the time frame the user requests.


EX:

Hours worked sheet:
9/22/04 15
9/23/04 4
9/24/04 10


Report Sheet:
Data Range: __________ (user enters: 9/22/04 - 9/24/04)
Hours worked: 29

Thanks,
David


--
DavidMunday

Hi!

On your report sheet you need 2 cells to enter the data range, one for the
start date and one for the end date.

Then, assume on the Hours worked sheet the dates are in column A, A2:A100
and the corresponding hours worked are in column B, B2:B100.

Formula on Report sheet assuming start date is in cell B2 and end date is in
cell C2:

=SUMPRODUCT(--(Hours_worked_sheet!A2:A100=B2),--(Hours_worked_sheet!A2:A100<=C2),Hours_worked_shee t!B2:B100)

Biff

"DavidMunday" wrote in
message ...

I do not know any VB but I have experience with C and Java. I have data
sets on a worksheet that are from different days, which are then
orgranized into one worksheet per week. Can anyone explain how I could
make a form inside a work sheet that would allow me to enter in a pair
of dates to display a particualr summation of the data set in a graph
depending on the time frame the user requests.


EX:

Hours worked sheet:
9/22/04 15
9/23/04 4
9/24/04 10


Report Sheet:
Data Range: __________ (user enters: 9/22/04 - 9/24/04)
Hours worked: 29

Thanks,
David


--
DavidMunday