Actually, I think this is what you were looking for.

=IF(AND([cpleger.xls]Sheet1!N8=2,Sheet1!I8<""),[cpleger.xls]Sheet1!I8,"")

This is where if Sheet1!N8 = 2 and Sheet1!I8 is not blank it will
return the date in Sheet1!I8. If Sheet1!N8 =2 and Sheet1!I8 is blank,
it will return blank.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=517023