how do I set up a validation rules with two data rules

how do I set up a validation rules with two data rules

Post by VHJ1ZH » Tue, 17 Oct 2006 11:43:01


I am trying to creat a validation rule that is: End date greater than date
entered in cell C23 and less or equal to 5/21/06. What I don't understan is
how to set up the second rull less or equal to 5/21/06.
 
 
 

how do I set up a validation rules with two data rules

Post by TWFya0 » Tue, 17 Oct 2006 13:42:05

Hi Trudy,

Data, Validation and choose 'Date' in top box. Select 'between' in next box.
Click into the Start date box and then click on C23. In the End date box,
type =5/21/2006.
Click OK and it should work
--
Hope this helps,
MarkN