I have created a gantt chart in Excel, that highlights the cells with a color, according to the amount of days an activity has. I use a Conditional Formatting (CF) formula on a group of cells (=OG(J$6>=$E7;J$6<$F7) ) for that. If the formula is true, then the cells change color. My problem is, that the calendar includes Saturdays and Sundays (weekends).
How can I write a formula in CF that will jump the weekends and count the rest of the days on monday.
Fx. An activity starts on a thursday and last 5 days, then it shall highlight T, F, M, T and W.
In advance, thanks for the help.
Solved by T. B. in 19 mins