Exclude weekends in a Gantt chart

I am editing a Gantt chart created by someone else, and everything works fine, except that the day ranges span over weekends, which makes it unusable. I recall having used the Workday formula in the past, but I don't see how I can use it here.

I am using conditional formatting to show risk levels (by color), and then plotting those color bars for each day. This works fine, but as you can see, the weekends are included. The cells are using a rather complicated formula, so I don't know where I would add the WORKDAY.

Thanks.

It is not shown in your picture, but how do you generate the dates which would appear from your formula to be in row 5 ? If the date in a cell is just 1 added onto the previous date, then you can change this to check if the previous date was a Friday, and if so then add 3 on rather than 1, along the lines of (in J5):

=I5+IF(WEEKDAY(I5,2)=5,3,1)

then copy this across. This assumes that I5 contains the first of the month (or starting date).

Hope this helps.

Pete

Thanks Pete. I think I understand what you are saying and I will try it.