Hi

Why can't the Validation list have dates going backwards?
In cell A1 =Today()
In A2 =A1-1
Copy down for as many dates as you want in your validation range.


--
Regards

Roger Govier


"Paperback Writer" wrote in
message ...
I'd like to create a dropdown where the user selects a date. However,
I'd
rather not use data validation. Data validation requires that I have
a
column somewhere filled with dates. I'd like the dropdown to have
those
dates going backward from today's dates - forward dates are not
allowed.

Thoughts?