Prev: How to insert an Excel landscape document into a portrait Word doc
Next: Align
From: Gabe on 11 May 2010 19:32
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
From: Dave Peterson on 11 May 2010 19:59
I'd try:

Select A1
Data|Validation (xl2003 menus)
formula is:
=AND(ISNUMBER(A1),A1>=DATE(2009,12,1),A1<=DATE(2012,12,31),A1<=A2)



Gabe wrote:

> 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

--

Dave Peterson
From: Gary''s Student on 11 May 2010 20:13
Data > Validation > Custon > FormulaIs:

=AND(A1>40148,A1<41274,A1<A2)
--
Gary''s Student - gsnu201002


"Gabe" wrote:

> 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
 | 
Pages: 1
Prev: How to insert an Excel landscape document into a portrait Word doc
Next: Align