If you need the number of days between two dates, just subtract one from the other and format as number.
DAYS360 is used in certain areas of finance and insurance and has its own set of rules (two sets, actually), which are explained
in HELP.
Unless you explicitly require the 360-day system, don't use DAYS360.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Candentco Creative Collection" .com wrote in message
...
|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