Workday in formula

Hi,

I am trying to amend a GANT chart template I found on Internet.


To create pattern for the GANT chart, a formula is used as conditional formatting:

=AA$5=MEDIAN(AA$5,$D6,$D6+$E6-1) where AA5 is the cell date, D6 start date and E6 number of days (duration).

This works fine if the dates are in order, but I have changed the date range to only use working days. As this Capture.PNG shows, there should be 5 days with pattern on the chart, but only 4 comes up as the formula expects May 3rd to be the last day of activity.

I would really appreciate if someone could point me in right direction on how to amend the formula to exclude weekends.


Cheers,
WG