custom validation


Posted by Marianna Zahurak on November 09, 2001 4:16 AM

This custom validation formula seems to be giving me the expected answers when I test it in a column in the spreadsheet, but when I put it in the validation box and then go to test it's use, it doesn't work. The formula is:

=AND(D2>B2,E2="")

D2,B2 and E2 are date columns. When I go to use it, the validation stops me if I try and enter a date in D2 and there is already a date in E2 (this is correct),
but does not stop me if D2 is an earlier date than B2?
Is this kind of checking possible with Excel?
Thanks for any help!
Marianna

Posted by Aladin Akyurek on November 09, 2001 5:38 AM

This works:

=(LEN(B2)=0)*(D2>B2)

which is in fact equivalent to you formula.

Aladin

===========

Posted by Marianna Zahurak on November 09, 2001 7:48 AM

still not working....

This seems to be working in the same way as my previous formula. Even though the equasion evaluates correctly, the box does not stop data entry if the date in D2 is earlier than the start date which is entered in B2. Does Excel allow formulas like this in custom validations? I really need to figure this out. Please help again!
Thanks. Marianna

Posted by Juan Pablo on November 09, 2001 8:05 AM

Re: still not working....

Does column D have the validation as well ?



Posted by Aladin Akyurek on November 09, 2001 8:09 AM

Re: still not working....

Strange. I've just sent you a workbook to have a look at.

Aladin