Possible to chart data for dates implicit within a range?

[Nechama]

I have a list of computer programs with start and end dates for each. I need
to determine how many programs were running on my system on any given day.
Can I get this data for individual days between the start and end dates
without creating columns for each intermediate day? Ex.: Program 1 ran from
01/01/2005 to 01/14/2005. Program 2 ran from 01/06/2005 to 01/22/2005. Is it
possible to chart the total number of programs running on 01/08/2005 without
manually creating a column for that date?

Thanks,
Nechama

 

[Jon Peltier]

You can compute this with formulas. Star with data in A1:C4 as follows:

Start End
Prog A 1/1/2005 1/14/2005
Prog B 1/6/2005 1/22/2005
Prog C 1/10/2005 1/20/2005

In E1 place the data in question (1/8/2005). In F1 enter this formula:

=SUMPRODUCT((B2:B4<=E1)*(C2:C4>=E1))

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______