With a static date in D4, you could use =D4+1 to populate the calendar.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
Gantt chart
To build a Gantt chart, you can use Conditional Formatting with a formula based on the AND function. In the example shown, the formula applied to D5 is: =AND(D$4>=$B5,D$4
