Just subtract one from the other, and format as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"themax16" wrote in
message ...

Afternoon.
I have 2 lists of dates... one is for an estimated delivery date and
the second is the actual date. If the date's do not match ( the
delivery is late) then i need it to calculate the number of days that
its late. How can i do this calculation for a date format?
Thanks
James


--
themax16
------------------------------------------------------------------------
themax16's Profile:
http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=478181