Dear npr

The formula is shown as Holidays!E6:E7 because I renamed the worksheet containing the holiday dates to Holidays otherwise the formula will be Sheet2!E6:E7

Sunny

Thanks Sunny!

Have a Good weekend.

I wish I could seat with you 2 min. with my laptop Sunny 🙂

Weird things as I touch (extend) your working example

When I do the holidays it does nor skip (add) the yellow dates

Also, I made a print of the formulas in your file, and I cannot understand the ~inconstancy of dates-ranges - - print is enclosed

Dates of holidays are selected with no $ sign I see..   that allows the range to be changed as one goes down the gantt sheet (??..) 

It's no big deal operationally -  I could just add the few holidays 'manually' - it's more of an interest to make it work 🙂

Thanks a lot Sunny.

Hi npr

My apologies. The formula should be Holidays!$E$6:$E$7. I think I forgot to change it back after testing with different dates. 

Sunny

Thank you very much Sunny!!

I will try again to make it work.

Hi Sunny,

There's only one little program left 🙂 I don't see that HOLIDAY days are deduced 

I'm enclosing a screenshot that demonstrates the problem (with the formula you suggested)  if the excel sheet is needed I can attache it too

Hi npr

I think it is better you upload the file and explain which part is not correct.

Please do not include sensitive data.

Sunny

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!!!

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

Ahh-Right!  🙂

Thank you very much Sunny.

Good to see there is a 'solid' reason why it does not work  🙂   Will sure try.

Dear Sunny,

Check facebook messages sometime 🙂   and Linkedin too

Thanks once again for the kind help/

Great to see Sunny was able to help.

Sunny is Knowledgeable, Kind and patient! 🙂

Glad to hear you managed to make it work, with Sunny's help of course.

Thank you Catalin Bombea.