Hi all,

I am using the below spread sheet

Task Working days Start date End date
1 7 days 28/05/2010 07/06/2010
Analysis 1 2 days 28/05/2010 31/05/2010
Develop 2 1 wk 01/06/2010 07/06/2010
2 4 days 01/06/2010 04/06/2010
Analysis 1 1 day 01/06/2010 01/06/2010
Develop 2 3 days 02/06/2010 04/06/2010
3 7 days 02/06/2010 10/06/2010
Analysis 1 2 days 02/06/2010 03/06/2010
Develop 2 1 wk 04/06/2010 10/06/2010

I need to calculator the amount of working days based on if the days are for
analysis or development. I would like to return the value in one cell for
development and analysis work? Any one now how to do this?