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

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
 

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


"Trudy" wrote:

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.