Date validation between specified dates
Posted by Garry on June 18, 2000 11:54 PM
I am trying to restrict dates entered in Cells A1:A20 to the range between the values specified in Cells B1 and B2.
Cell B1 picks up todays date, B2 is calculated to be 91 days earlier than B1.
I am using the Data/Validation, Date, Between, B1, B2 method.
This doesn't work. Under test, changing the Between option to a Greater than option, does work and allows only dates greater than that in cell B1.
What's wrong !!