Restricting date entry relative to current date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to limit a date entry to no greater than four days from the current
date. The only Excel data validation schemes call for restricting by
specific dates. This validation is inadequate for my purposes.
 
One way:

Data/Validation:

Allow: Custom
Formula: =(A1-TODAY())<=4
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation With Date Range 1
Data validation: want input restricted to date value or N/A 2
Testing a cell value for a specific weekday. 3
Excel Average dates help 0
Excel Vba to change displayed year automatically. 14
Incremental dates based upon specifications 1
Data Validation -- Dates 4
Prevent a Weekend date entry 4

Back
Top