On Thu, 13 Oct 2005 10:12:25 +0100, shoulders
wrote:


Please help, I know this is probably a really quite simple function but
i have been puzzling over this for couple of hours now.

I am trying to work out the formula that will provide the number of
days between two different dates for example 10/01/2005 - 10/13/2005 =
## days (american date format). If anyone could provide assistance that
would be great and save me a lot of hassle.

Thanks

Shoulders

If your first date is in A1; and your later date is in A2, then the formula is:

=A2-A1 (format as General or Number)

Excel stores dates as serial numbers starting with 1/1/1900. So to get the
number of days between dates, you merely need to subtract one from the other.


--ron