Two date validations
Data Validation Custon FormulaIs:
=AND(A140148,A1<41274,A1<A2)
--
Gary''s Student - gsnu201002
"Gabe" wrote:
How do I create two validation rules for one cell containing a date?
1. The date (Cell A1) must be between a certain range (12/01/2009 and
12/31/2012).
2. The date must not be greater than Cell A2.
So far I got the first rule working, but I can't figure out how to do both.
Any advice would be greatly appricaiated.
Thanks,
~Gabe
|