← Prev in month ← Prev in thread
Next in thread → Next in month →

[office-formula] predraft 8 of 2007-12-28, section 6.9.6, function days360 comment

From
Roel <>
Date
2008-02-13T21:30:42+00:00
ID
Thread
[office-formula] predraft 8 of 2007-12-28, section 6.9.6, function days360 comment
Hello,

I believe that the test case for the function 'days360' is wrong.

The days360 function (as given in the test-case) should result in '159' 
instead of '-162'.

The current implementations of this function in
- excel 2002 (xp)
- excel 2003
- excel 2007
- openoffice.org 2.3.0
- openoffice.org 2.3.1
- kspread 1.6.3
all give '159' as a result.

The given result of '-162' is obtained when one uses the 'days'-function 
instead of the 'days360' function.

-- 
Roel
← Prev in month ← Prev in thread
Next in thread → Next in month →