I need help with this and hopefully someone can assist! I am working with a
spreadsheet that has different start and finish dates during the fiscal year
(Oct - Sept). There are man hours associated with each person and their
availability. HOW CAN I FORMULATE TO SHOW THE # OF PEOPLE ASSOCIATED &
AVAILABLE AS A RESOURCE WITH EACH UNIQUE TIME PERIOD?????

Example:

Name Start Finish Hrs/Wk 2nd dates hrs/wk
Person A 10/1/07 - 9/30/11 40
Person B 10/1/07 - 8/4/08 40 8/4/09 - 9/30/11 40hrs
Person C 5/30/09 - 9/30/11 40
Person D 2/11/08 - 8/15/09 20 9/10/10 - 9/30/11 20hrs
--
DB