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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top