|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2010, 12:32 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
May 12th, 2010, 12:59 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two date validations
I'd try:
Select A1 Data|Validation (xl2003 menus) formula is: =AND(ISNUMBER(A1),A1=DATE(2009,12,1),A1=DATE(201 2,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
|
|
#3
May 12th, 2010, 01:13 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two date validations
Data Validation Custon FormulaIs:
=AND(A140148,A141274,A1A2) -- 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
