Tim Deaton wrote the following on 5/9/2008 10:53 PM:
The reason Bryan is correct is in the name of the function: "360".
DAYS360() is designed to assume that every month has 30 days. It is
used for certain financial calculations. If you count DAYS() FROM May
15 to June 15 you will get 31. If you count DAYS360() from May 15 to
June 15, you will get 30.
Tim Deaton
Ok, my apologies. I stand corrected on the Days360 function. However, as
was commented earlier, the correct function (if your looking for
compatibility since Walter was saving it as an .xls file) is still not
Days(). The bug that Walter discovered is that OpenOffice is converting
that formula to Excel's format (comma separator instead of semicolon)
when it shouldn't be converted because Excel doesn't understand it. It
would appear that the only major spreadsheet software using the Days()
function is OpenOffice. Excel 2003 and 2007 do not support it. Quattro
Pro X3 doesn't support it, Gnumeric doesn't support it. I can't explain
why Joe Conner's Excel viewer displays the results of this function
while Excel itself wont except to say that they are two separate pieces
of software.
--
Jack D. Lewis
NativeWinds LLC
1448 MT Hwy 2 West
Whitehall, Montana 59759
www.nativewinds.montana.com
This email and any attachments are intended only for the use by the party to
which it is addressed and may contain information that is privileged,
confidential, or protected by law. If you are not the intended recipient, you
are hereby notified that any dissemination, copying or distribution of this
email or its contents is strictly prohibited. If you have received this message
in error, please notify the sender immediately by replying to the message and
deleting it from your computer.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
