View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gabe gabe is offline
external usenet poster
 
Posts: 39
Default Two date validations

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