...need formula....
...need formula....
(OP)
Hi
I need formula which calculate days after one task to the next task? I'd like to put that formula in column. Could you somebody help me?
Example:
milestone - date of delivery product A
task 1 / start date / finish date / [COLOR="red"]number of days between delivery A and start task 1 /number of days between finish date task 1 and start date task 2[/COLOR]
task 2 / start date / finish date / [COLOR="red"]number of days between finish date task 1 and start date task 2 /number of days between finish date task 2 and start date task 3[/COLOR]
task 3 / start date / finish date / [COLOR="red"]number of days between finish date task 2 and start date task 3 /number of days between finish date task 3 and start date task 4[/COLOR]
task 4 .......................etc
Could you somebody help me ?
Best regards
Jarek
I need formula which calculate days after one task to the next task? I'd like to put that formula in column. Could you somebody help me?
Example:
milestone - date of delivery product A
task 1 / start date / finish date / [COLOR="red"]number of days between delivery A and start task 1 /number of days between finish date task 1 and start date task 2[/COLOR]
task 2 / start date / finish date / [COLOR="red"]number of days between finish date task 1 and start date task 2 /number of days between finish date task 2 and start date task 3[/COLOR]
task 3 / start date / finish date / [COLOR="red"]number of days between finish date task 2 and start date task 3 /number of days between finish date task 3 and start date task 4[/COLOR]
task 4 .......................etc
Could you somebody help me ?
Best regards
Jarek