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" wrote in message
...
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!