formulae-count how many days between two dates

[tooks]

I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two
dates here)gives the answer 1 as in one year.........help meeeee please!

[Ragdyer]

You want the DateDif() function.

It's undocumented, except in XL2k, so Chip Pearson has fully explained it in
his web site:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"tooks" <tooks@discussions.microsoft.com> wrote in message
news:A5E5AE38-6510-4C36-BEA9-A2FAA62E5B18@microsoft.com...
> I require a formula that will count how many days between two dates.eg
> 23/05/02 and23/05/03. Using the rcommended formula days360(the two
> dates here)gives the answer 1 as in one year.........help meeeee please!

[Ron Rosenfeld]

On Sun, 15 May 2005 16:31:02 -0700, "tooks" <tooks@discussions.microsoft.com>
wrote:

>I require a formula that will count how many days between two dates.eg
>23/05/02 and23/05/03. Using the rcommended formula days360(the two
>dates here)gives the answer 1 as in one year.........help meeeee please!

In Excel, dates are stored as serial numbers. So if you want the actual number
of days between two dates, merely subtract one from the other.

A1: 23 May 2002
A2: 23 May 2003

B1: =A2-A1 := 365 (format as General)

=DAYS360(A1,A2) would give a result of 360. This formula is used for certain
accounting system that assume 30 day months.


--ron