Forum Discussion
Using a Formula To Determine A Task's Cost Allocation Per Week Based On a Task's Start and End Date
Hello Everyone, I need help generating a formula that can do the following: Determine how many task working days (Mon-Fri) there are given a task's start and end date. Out of those days, determine ...
Hi dmartin215
Please find below construction of the formula
=ROUND($B4/NETWORKDAYS.INTL($C4,$D4,1),2)*SUM(--(IF(WEEKDAY((C4+ROW($A$1:INDIRECT("A"&($D4-$C4)+1,TRUE))-1),2)<=5,INDEX($A$10:$A$15,MATCH(($C4+ROW($A$1:INDIRECT("A"&($D4-$C4)+1,TRUE))-1),$B$10:$B$15,1)),0)=E$3))
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
ExcelExciting Nice formula!! Thank you sir. Per the picture it appears the first value ($7,142) is correct, however when I open the file it reverts to $9,999. And for task B, the value for both week 3 and 4 should be $6,000.
