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
Bookmarks