If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
timeline?
I have the data below:
Number of Jobs BeginDate EndDate TotalDays 107 1/2/04 2/3/04 31 50 1/23/04 2/20/04 28 etc... How can I tell how many days there will be an overlap. In other words, there are 107 jobs going, and starting on the 23rd there will be 50 more jobs, but only until 2/3 when the first 107 jobs are completed. During the time between 1/23 and 2/3 I want to know how many jobs in total are going on. |
#2
|
|||
|
|||
timeline?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Leslie" wrote in message ... I have the data below: Number of Jobs BeginDate EndDate TotalDays 107 1/2/04 2/3/04 31 50 1/23/04 2/20/04 28 etc... How can I tell how many days there will be an overlap. In other words, there are 107 jobs going, and starting on the 23rd there will be 50 more jobs, but only until 2/3 when the first 107 jobs are completed. During the time between 1/23 and 2/3 I want to know how many jobs in total are going on. |
#3
|
|||
|
|||
timeline?
Leslie,
Try =SUMPRODUCT((B1:B100=DATEVALUE("23/01/2004"))*(C1:C100=DATEVALUE("03/02/20 04"))*(A1:A100)) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Leslie" wrote in message ... I have the data below: Number of Jobs BeginDate EndDate TotalDays 107 1/2/04 2/3/04 31 50 1/23/04 2/20/04 28 etc... How can I tell how many days there will be an overlap. In other words, there are 107 jobs going, and starting on the 23rd there will be 50 more jobs, but only until 2/3 when the first 107 jobs are completed. During the time between 1/23 and 2/3 I want to know how many jobs in total are going on. |
Thread Tools | |
Display Modes | |
|
|