Hi
I have spreadsheet that uses the following formula to work out the duration of a task and then spreads it over the months.(thanks for help on previous post)
What i now need to do is to take into consideration the % completed and spread this over the remaining months?
Any help greatly received
The spreadsheet is set out as follows:
Names Status % Complete Aug-07 Sep-07 Oct-07 Nov-07 Dec-07
A A 50% 4.76% 0% 0% 0% 0%
A FE 10% 0.00% 18% 0% 0% 0%
I have spreadsheet that uses the following formula to work out the duration of a task and then spreads it over the months.(thanks for help on previous post)
What i now need to do is to take into consideration the % completed and spread this over the remaining months?
Any help greatly received
Code:
=IF(STATUS="FE",0.75,IF(STATUS="E",0.25,1))*IF(OR($D3>H$1,$E3<G$1),0,NETWORKDAYS(IF($D3>=G$1,$D3,G$1),IF($E3>H$1,H$1,$E3)))/21The spreadsheet is set out as follows:
Names Status % Complete Aug-07 Sep-07 Oct-07 Nov-07 Dec-07
A A 50% 4.76% 0% 0% 0% 0%
A FE 10% 0.00% 18% 0% 0% 0%