Maybe

=OR(AND(B5=DAY(A1),B5<=DAY(A2)),AND(B5=DAY(A1),A2 =""))

you need to deselect ignore blank

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Gos-C" wrote in
message ...

If the day in A1 is 24 and the day in A2 in 28, the keyer is allowed to
enter 24, 25, 26, 27 or 28 in cell B5, for example. If the day in A1
is 31 and A2 is blank, then the keyer is allowed to enter 31 and
nothing else.


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile:
http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=537032