Hi,

I have the following formula in cell *CP2* that evaluates to blank
(""):

=IF(BU2+7<DATE(YEAR(DATE!E23),MONTH(B2)+1,0),BU2+7 ,IF(AND(BU2+7=DATE(YEAR(DATE!E23),MONTH(B2)+1,0),C N2<DATE(YEAR(DATE!E23),MONTH(B2)+1,0)),DATE(YEAR(D ATE!E23),MONTH(B2)+1,0),IF(AND(BU2+7DATE(YEAR(DAT E!E23),MONTH(B2)+1,0),CN2<DATE(YEAR(DATE!E23),MONT H(B2)+1,0)),DATE(YEAR(DATE!E23),MONTH(B2)+1,0),"") ))

BU2[/b] CONTAINS A FORMULA THAT EVALUATES TO *28-07-2006

DATE(YEAR(DATE!E23),MONTH(B2)+1,0)* EVALUATES TO *31-07-2006

B2* CONTAINS FORMULA THAT EVALUATES TO *JULY

CN2* CONTAINS FORMULA THAT EVALUATES TO *31-07-2006


When I set the [b]Validation citeria* to *Custom*, and entered the
following formula:

=OR(AND(CK5=DAY($CN$2),CK5<=DAY($CP$2)),AND(CK5=D AY($CN$2),$CP$2
=""))

I get the message "The formula currently evaluates to an error. Do you
which to continue?"

When I choose "Yes," it does not accept *31* in cell CK5, (but when I
delete the formula in cell CP2 - leaving the cell blank, it accepts 31
only)

I know that the problem is being caused by the blank ("") in cell CP2.
Any help in fixing that problem?

Thanks,
Gos-C


--
Gos-C


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