Formula to calculate number of days between Dates

[themax16]

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

 

[Bob Phillips]

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

--

HTH

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

 

[Ron Rosenfeld]

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