try

=IF(A1="not yet",DATEDIF(B1,C1,"d"),DATEDIF(B1,D1,"d"))



Ruthki


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=467948