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" wrote:
> 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:
>
> > 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" wrote:
> >
> > > 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:
> > >
> > > > 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
|
Similar Threads
