View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default 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.