The equipment room can take bookings from 7 through 18 September 2026. A date rule on the request sheet catches the most likely mistake, a booking for the day after the room closes.

Apply the rule only to the booking cells

Select D6:D25 in the booking sheet. Open Data > Data Validation, add a rule, and confirm the range. Choose Date with the operator for dates between two values. Enter 7 September and 18 September 2026 in the date format your workbook accepts.

In the rule’s options, choose Reject input if the booking sheet should block out-of-window dates. Use the warning setting only when the workflow allows an exception.

A sample validation form shows D6:D25 and date limits of 7 and 18 September 2026.

Illustrated rule. Apply it only to the booking cells.

Test September 7, 18 and 19

Type September 7 and September 18 into two test cells inside the range. Both dates should be accepted. Try September 19 and check that it is rejected when the rule is set to reject. Test one cell outside D6:D25 to make sure the rule did not spill into another input area.

A boundary test card lists September 7, 18 and 19 with their expected acceptance or rejection.

Example test cases. Type each date in the workbook after reopening it.

Review dates already in the sheet separately. The rule does not repair old bookings. Save the XLSX, reopen it and repeat one accepted and one rejected entry in a working copy. If staff paste bookings from another list, test that path too.