validation is not working

[faizee]

i have this formula in my date column validation

=AND(W3>STARTDATE,W3<ENDDATE)

i defiend STARTDATE as my first date, and ENDDATE is last date..

but in validation, is not working...?

 

[Useful]

Hi, what do you want to do isn't so clear. But as I understand you may use Allow:Date/Data:between/Start date: /End date:

 

[faizee]

yes, you are right,
=AND(W4>STARTDATE,W4<ENDDATE)

where i defined startdate as 1jan12 and defined enddate as 31dec12
so i put this formula =AND(W4>STARTDATE,W4<ENDDATE) in validation custom,
then it should not allow any date before 1jan12 or les than 31dec12.


but its not working..

 

[Useful]

Hi again,
(an example activate H3 and use this formula in validation (Custom))
D1=startdate
D3=enddate
should work fine,

=AND(H3>=D1,H3<=D3)

 

[faizee]

why 'define name' does work in validation,
like if define D1 as startdate and D2 as endddate, it wont work..

why is that so?

 

[Useful]

are you typing like that?

=AND(H3>=startdate,H3<=enddate)

 

[faizee]

yes. 100%
but its not working,,

 

[Jonmo1]

Can you post the contents of the "Refers To" box for the 2 named ranges ?
and what do these formulas return
=ISNUMBER(Startdate)
=ISNUMBER(Enddate)

Also, back to the first question, why are you using a custom formula for the validation?
Why not just Select DATE from the dropdown box, and enter the dates there?

 

[Useful]

yes. 100%
but its not working,,

Hi,
make sure that your defined names are correct (you may use defined names by pressing "F3")
Also, have you checked my previously posted an examlpe in order from A to Z that posted today at (Today, 10:05 AM)?
(this works fine)