Home |
Search |
Today's Posts |
#1
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
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two date validations
Data Validation Custon FormulaIs:
=AND(A140148,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validations | Excel Discussion (Misc queries) | |||
Data Validations | Excel Worksheet Functions | |||
2 Data Validations Q | Excel Worksheet Functions | |||
data validations | Excel Discussion (Misc queries) | |||
3 data validations | Excel Worksheet Functions |