how to chart who was working when

[miggirl]

Hi there, I'm looking for some help in producing a chart. My
organization has hired about 100 folks since 1991, each on contracts of
varying lengths of time. Some peoples' contracts have ended, and some
have been renewed. I set up some worksheets inputting their names,
start and end dates with the intent of producing a graph that will tell
me exactly how many people were working for us at one time, based upon
6 month intervals. For example:
John Doe 7/29/91 - 3/31/05
Jane Doe 6/21/94 - 2/20/96
Jake Doe 8/2/01 - 4/18/03
I would like a chart that can tell me how many people were employed
from Jan 1 - June 30 1995, June 30 - Dec 31 1995, etc.

I have used DATEDIF functions to tell me the lengths of peoples'
contracts with regard to TODAY, but am unsure how to go about getting
the chart I need.

Thank you for your help!
Sara

 

[Peter Atherton]

Sara

Test Data
Start End Jan-95 Jul-95 Jan-96 Jul-96
29/07/91 31/03/05 1 1 1 1
21/06/94 20/02/96 1 1 0 0
02/08/01 18/04/03 0 0 0 0
2 2 1 1

Jan 95 heading is in E1
Formula in E1 is =IF($C2<=E$1,AND($D2>=F$1)*1,0)

Copy this formula accross and down and total below.
Use the totals for the Chart data and the Date heading for
the X axis labels.

Sorry for the delay - I thought it would be answered by
now.

Regards
Peter
Regards