VIP
Trusted Members
June 25, 2016
December 22, 2016
Sunny, your Good will and patience are greatly appreciated!
here's the file.
I placed holidays right on the beginning so that we can count easily (10-Jan, 11-Jan)
The light blue is the holidays cond. format.
In line 11 There should be 14 work days though there are only 12. The gantt should have reached Jan.21 am I wrong ?
Thanks very much!!!
VIP
Trusted Members
June 25, 2016
Hi npr
You did not add the holidays into your conditional formatting.
Your formula :
=AND($E9<=J$8,WORKDAY.INTL($E9-1,$F9,7)>=J$8,AND(WEEKDAY(J$8)<>6,WEEKDAY(J$8)<>7))
Actual formula should be :
=AND($E9<=J$8,WORKDAY.INTL($E9-1,$F9,7,Holidays!$D$6:$D$15)>=J$8,AND(WEEKDAY(J$8)<>6,WEEKDAY(J$8)<>7))
You will need to add the Holidays to all your Conditional formatting.
Give it a try.
Sunny
1 Guest(s)