Hi,

Book1.xlsx

in this file, the next date only appear, if data are entered in both sheets for the previous day (Data in Column C, Date appears in Column B9

Only, if the date appears, data can be entered.

Might not be the best way, but should work