Data Validation for dates

[ArcticWolf]

Hi,

In cell A2 I have a data validation list which contains dates (01-01-2009 to
31-12-2009) and the column heading is Order Received Date.
In B2 I want the the user to select another date from a data validation list
(Order Shipped Date) but I don't want them to choose a date that is earlier
than the date in A2. Is this possible to do? I've tried a custom formula
but I can't figure out how to get it to work!

Thanks in advance,

AW

 

[Stefi]

It doesn't need any formula.
Data>Validation>
Select Date from the upper drop down list (I'm not sure what's the English
caption, I use a Hungarian language version, maybe Allowed?),
select Greater than or equal to from the 2nd drop down list (maybe relation?),
put the cursor in the start date field and click on cell A2,
do other settings on Message and Error tabs,
and press OK!

Regards,
Stefi

„ArcticWolf†ezt írta:

 

[ArcticWolf]

Thanks for the reply Stefi.

I need the end user to select from another data validation list in B. IE I
have two data validations one in A and one in B.
I need the user to select a date from the validation list in B, but only
choose a date that is => than A. We can't have a shipped order date before
the order was received!

Thasnks,

Peter

 

[Stefi]

In my opinion a validation list containing 365 elements is not very handy,
but if you want a subset of it starting with the date in A2, here it is (in
my example "days" stands for a named range of 365 day - source of validation
list in A2):

=OFFSET(INDEX(days,1),MATCH(A2,days,0)-1,0,COUNT(days)-MATCH(A2,days,0)+1)

Use it as source for validation list in B2!

Regards,
Stefi


„ArcticWolf†ezt írta:

 

[ArcticWolf]

I agree Stefi, but my end users aren't PC literate and you would not believe
what they try to enter in the cell that blatantly states 'date'!

Thanks for this it works perfect.

ATB,

AW

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„ArcticWolf†ezt írta: