Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |