Synthetic fixed reference date exercise. Formula separator shown as semicolon.
A1 Task; B1 Due; C1 Status; E1 Reference date; E2 =DATE(2026;4;3)
A2 Draft; B2 =DATE(2026;4;2); C2 Open
A3 Review; B3 =DATE(2026;4;3); C3 Open
A4 Send; B4 =DATE(2026;4;1); C4 Done
A5 Schedule; B5 empty; C5 Open
A6 Archive; B6 =DATE(2026;4;4); C6 Open
A7 Text-date check; B7 apostrophe then 2026-04-02; C7 Open
Rule for A2:C7: AND(ISNUMBER($B2);$B2<$E$2;$C2<>"Done")
At April 3 only row 2; at April 4 rows 2 and 3.