RE: compute the difference between two dates accurately

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Peo Sjoblom" <PeoSjoblom@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 29 Apr 2005 13:08:14 -0700

=A1-B1

where A1 holds the later date and B1 the earlier date, format as general
DATE260 is an accounting function

Regards,

Peo Sjoblom

"Dilly" wrote:

> Date360 gives an inacurate answer that over the course of 20 years can be
> over a month. Is there an accurate way of computing the difference between
> two dates?
.

References:
- compute the difference between two dates accurately
  - From: Dilly

Prev by Date: Re: compute the difference between two dates accurately
Next by Date: Re: compute the difference between two dates accurately
Previous by thread: Re: compute the difference between two dates accurately
Next by thread: Re: compute the difference between two dates accurately
Index(es):
- Date
- Thread

Relevant Pages

Re: Allowing for more than 15 digits when downloading from another source
... Then back to excel and rightclick|paste special. ... > "Peo Sjoblom" wrote in message ... >> in step 3 you can select text under column data format. ...
(microsoft.public.excel.misc)
Re: Converting and sorting US dates into European format?
... will default to date format when using the DATE function just select the ... > Best regards, ... >> Peo Sjoblom ... >>> always like the double digit months and dates. ...
(microsoft.public.excel)
Re: summing columns
... Use a format of ... will return negative with a preceding minus ... Regards, ... Peo Sjoblom ...
(microsoft.public.excel.worksheet.functions)
Re: value of #s in column if between dates
... No need to array enter it ... > format and didn't know how. ... >> Regards, ... >> Peo Sjoblom ...
(microsoft.public.excel.worksheet.functions)
Re: =SUM(A1:A5)*24 for totalling hours and minutes is not working
... or format as general and use ... Regards, ... Peo Sjoblom ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)