At 14:51 09/05/2008 -0600, Jack D. Lewis wrote:
Yes I understand that Excel is not the real issue here. My point, which I obviously stated incorrectly, is that the formula should be DAYS360. This formula is supported by both Excel and Calc and it does not require you to press the enter key when you reopen the document. When using the DAYS360 formula, you have to reverse the two dates. IE: DAYS360(C4;B4)
Sorry, but DAYS360() won't wash. This function is designed to give the wrong answer for the difference in days between two dates, which is apparently needed in some financial calculations. The original enquirer was using DAYS(), so he must have wanted the correct answer instead. DAYS360() won't work for that. The function he needs is called subtraction! It is no doubt simply because the DAYS() function is unnecessary that it is not provided in Excel.
In addition, the difference between DAYS360(), which you say does convert back and forth correctly, and DAYS(), which does not, is that DAYS360() exists in both Calc and Excel - so can be expected to behave - whereas DAYS() exists in Calc but not Excel. So I think it is a bit bold to claim that Excel is not the issue.
How does the Excel viewer show the correct answer using DAYS() if - as the Microsoft web site claims - the DAYS function is not provided in Excel? Here's my guess. Oh, and it *is* just a guess. How does Calc save a document if it includes a function not provided in Excel? Does it perhaps create a macro which will provide that function in Excel? If so, what happens when this macro - intelligible to Excel but not to Calc - is discovered in the document being reopened in Calc? Is that where and when the problem occurs? Does Calc somehow still think that DAYS() is a macro rather than a built-in function and find it doesn't have an intelligible (or any?) version of the macro to use? That would certainly explain the error message (#MACRO?).
It may still be a bug, though ... Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
