Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |