<always return 30 days in a month

Only if it is a complete month. 2/28/2006 and 3/31/2006 give 30.

Look at the definition of the several 360 days systems:, for example he

http://en.wikipedia.org/wiki/360_day_calendar

--
Kind regards,

Niek Otten

"jellorain" wrote in message
...
Seeing a problem that could possibly be an excel glitch in the days360
function.

I'm running O2k3sp2 and have tried this on several machines including
those
outside of our company build environment.

When attempting to calculate the number of days using this function
between
the dates 2/27/2006 and 3/27/2006, I return the number 30 (which is
correct
based on days360). Though when entering the dates 2/28/2006 and 3/28/2006
I
return 28 days. My understanding is that this function should always
return
30 days in a month, no matter which month is chosen. Can anyone enlighten
me
as to why this is happening? The result has been a significant loss of
funds
within our securities team in regard to interest accrual.

--
JL
TA
WB