Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm puzzled why Excel 2003 gives a difference in days as "-2" when using Feb 28th as the start and end date. I have the following dates in two columns ("H" and "I") like this: | 28.02.2006 | 28.02.2006 | and then a third column on the same line, line 1, which has the formula: =DAYS360(H1,I1) And this gives me the result "-2"... If I just change the date to 28.03.2006 for both, it works ok, resulting in "0". The formula is working on this sheet on every other occasion except on these "double-28.02.2006" dates.. I even tried adding the "true" or "false" methods after the formula, but no help. Can anyone help and/or clarify why this is so? thanks in advance, -pjt |