I have two date columns for which the difference between them is used for
several subsequent calculations. My problem is when I use DAYS360, the
result is not consistent, i.e.:

Column A Column B Result of DAYS360 function

05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
months)
05/01/2007 2/29/2008 298.0
or
1/1/2005 12/31/2005 360
12/1/2004 11/30/2005 359

So:

(1) Why does not Excel return 10 or 300 in the first example and 360 on the
last line of the second example or

(2) Does anyone have a another solution?

Many, many thanks!



--MVD
San Francisco, California