The quick and easy solution would be to simply enter in the due date as another calendar item.
The more complex solution would be to:
1: Add a CalendarItemDueDates named range that corresponds to a column.
2: Change the formula in the J:P columns to this (note you will need to adjust for each week and that it is an array formula and so confirmed with CTRL+SHIFT+ENTER):
=SMALL(IF(((CalendarItemDates=Calendar!A$4)+(CalendarItemDueDates=Calendar!A$4)),ROW(CalendarItemDates)),ROW(1:1))
3:Add in this conditional formatting formula (note you will need to adjust for each week):
=INDEX(CalendarItemDates,J5)<>A$4
See attached.
Bookmarks