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!
