AFAIK there is no DAYS() function in Excel. You just subtract one date from the other to get the number of days between them.
Maybe you mean DAYS360() function? 360 Days calculations have their own set of rules. 25 Seems to be the correct answer for your
example.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

" wrote in message
...
| In office pro 2003, excel the dates between function mis calculates i.e.
| creating a amortization for simple interest using the days() between
| function mis-calculates the number of days. i.e. aug 10, 2006 to sept 5, 2006
| is 27 days, date() function reports 25 days, causing interest and principle
| to be wrong and ending balance to be incorrect.
|
|