=DATEDIF(C8,D8,"d")

c8, d8 are dates, note that D8 should be greater than c8


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277226