Hi there, I'm trying to create an assessment calendar like the one above. Teachers will add in a start and end date and the corresponding boxes will be highlighted. I'm trying to figure out the formula for this in conditional formatting as the correct date along the range of dates in the year need to be highlighted. Each teacher needs their own section for inputting their assessments and I'm not sure how to put in the formula properly. I will use a drop down menu for teachers to select dates... would anyone be able to help with this? I tried following this guide but I'm not sure if it applies:

In this Sample, D2:T2, A3:B are all date format.

Apply range of the conditional formatting is: D3:T

The formula of the conditional formatting is as simple as:

=AND(($D$2:$T$2>=$A3),($D$2:$T$2<=$B3))

You can format te date value of D2:T2 into any format as you like, just make sure those cells contains a date value.