timeline?

[Leslie]

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.

 

[Bob Phillips]

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

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)