Formula to calculate number of days between Dates
 

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

Formula to calculate number of days between Dates
 

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

Formula to calculate number of days between Dates
 

On Fri, 21 Oct 2005 05:31:37 -0500, themax16
wrote:


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

In Excel, dates are stored as serial numbers.

So if your Estimated Date is in A1, and the Actual date in B1, the difference
would be given by:

=B1-A1

You must format the result as General or Number. Otherwise Excel will display
some date in the 1900's


--ron