TheMONTH functionis used to compare months in the header row.
When they are different, the month name is displayed.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
Gantt chart by week
To build a Gantt chart by week, you can use conditional formatting applied with a formula based on the AND function. In the example shown, the formula applied to D5 is: =AND((D$5+6)>=$B6,D$5
