Roberta,
Assuming A1= "Date", B1 = "Received Date" & C1 = "Total Days" then in
C2 enter:
=IF(ISBLANK(A2),0,DATEDIF(B2,A2,"d"))
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=502625