Forum Discussion
Gantt Chart Weekday Function
I am trying to use a gantt chart with conditional formatting for a project. I have my conditional formatting set up the following: =AND($D9<=H$5, WORKDAY($D9-1, $C9)>=H$5) problem is, some of the ...
Depends on logic. If duration 1 day always means next workday after the first worday (e.g. start is sat, first workday is Mon, duration =1, end = Tue which is Mon+1); 0 means start and end at first worday (e.g. for above is Mon), we may use
=($D9<=H$5) * (WORKDAY($D9-1, $C9)>=WORKDAY(H$5,-1) )