Excel Formula days360 1

[kastaman]

I'm trying to determine the # of days between 2 dates.
I've used the days360 formula but when the date is within a day, the field does not show "1" but "0".
Here is an example of dates involved:
10/01/2001 -> 10/02/01 = should be "1" day but it appears as "0".

Do you guys have any thoughts to this?

Thanks in advance!!

Kastaman

 

[ETID]

You want to use the datedif function....

examples:
----------------------
the number of elapsed days....

=datedif(a1,d1,"D&quot
----------------------
the number of elapsed months....

=datedif(a1,d1,"M&quot
-----------------------
check the help on datedif for more uses of this function

 

[Howi]

I get "1" using days360 using Excel 97 don't know why you are getting "0"
Datedif also shows "1".