How can I stop people entering a date outside my project’s allowed time period?

Select the cells where project dates belong, then open Excel’s data-validation settings for those cells. Set the permitted entry type to dates and define the minimum and maximum as your project’s start and end dates. Excel’s date-validation settings use the labels Start Date and End Date. Add an error alert and choose Stop if entries outside the range must be rejected. [S1]

For example, if your project period is 10 March 2026 through 30 June 2026, use those as the boundary dates. Treat them as placeholders: replace them with the dates that actually apply to your project. The rule applies to the selected cells, so check that the selection matches the places where dates should be entered.

Keep the message brief and tell the person both what is wrong and what to do next. For example:

Date outside project period. Enter a date from [project start date] through [project end date].

Replace the bracketed text with your actual boundary dates. If useful, add an input message that appears before entry, such as: Enter a project date between [project start date] and [project end date]. Excel supports an input message and a custom error alert; choose Stop when invalid entries must be rejected. [S1] Avoid a vague message like “Invalid”—it leaves the person guessing which dates are allowed.

Compare the selected range with the places where people are meant to enter dates. Include all intended date-entry cells and avoid applying the rule to unrelated fields. If the entry area is spread across separate blocks, check each block rather than assuming one selection covers them all.

Then test in a representative cell: enter a date within the allowed period, a date before it, and a date after it. Confirm that the in-range date is accepted and that each out-of-range attempt produces the expected Stop alert. Excel’s guidance recommends testing entries inside and outside the allowed range. [S1] If a sheet is protected or the workbook is shared, some validation settings may be unavailable. [S1]

Use this checklist each time you set up a project date field:

1. Identify the exact cells where people should enter dates.
2. Confirm the project’s actual start and end dates.
3. Select the intended cells and set date validation with those minimum and maximum values.
4. Add a helpful input message and an error alert; choose Stop to reject dates outside the range. [S1]
5. Check that every intended date-entry area is covered.
6. Test one in-range date, one date before the start, and one date after the end.

Copyable alert: Date outside project period. Enter a date from [project start date] through [project end date].

A successful test in one cell does not show that every intended cell has the rule. This setup checks entries in cells covered by the validation rule; it does not establish that dates elsewhere in the workbook follow the same limits.