data validation for range

  • Thread starter Thread starter crapit
  • Start date Start date
Hi,
I set data validation based on a range of date where "start date" and
"end date" reference from cell "A1" and "B1" respectively. If data
validation start at G7, meaning date in key at this cell must be of range
between the start date and end date, it is possible to have extra validation
where "end date" have past from the system date and validate failed!
 

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

Back
Top