Sum amount of days in another coloumn



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?

Jacob Skaria

Try the below

ColD and Col E contains dates...


Roger Govier

Hi Scott

Any chance you could modify your column B so that 1 wk is displayed as 5
rather than 1?
Also can you get rid of the text in those cells.

If not, then create a new column E with the formula

*5,IF(ISNUMBER(FIND("d",B2)),LEFT(B2,FIND(" ",B2)-1)*1,""))

If so, then in F1 enter Analysis and in G1 enter Develop
In F2 enter
Copy across to G2

If you can alter your column B, then just use


Hi thanks for this but i can not seem to get it to work....does it matter
that i am not using 2007 - it just returns a value error


Hi just got this to work - sort of. The problem i now have is the col A
contains loads of different titles for different pieces of work and i think
this is causing the Value return. Should this be a problem?


Go this to work now, all thought i have made some adjustments.


I have changed the formula to only include one variable so i can return each
variable in a different cell. However i would now like to change the
variable to ref a cell so i could change the title. The problem is when i
change "Analysis to say $M$1" it only returns value however if i change it
back to a word it retruns the correct number - thoughts?

Jacob Skaria

OK. Try the below which will search for the text string 'Analysis' and


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question