Select from a List
Assuming A2 is the validated cell, use Custom validation with the
formula
=(COUNTIF(daterange,A2)<0)*(A2<=TODAY())
daterange is the range of excel cells that contain admissible dates.
HTH
Kostis Vezerides
On 20 Ιαν, 11:25, Seanie wrote:
I have a dropdown list of Days set in a named range. Is it possible to
set a condition that you can only select a day that is <= to Today? -
all via Data Validation
|