Bruce Reed wrote the following on 5/9/2008 1:47 PM:
JOE Conner wrote:
I confirm what he is reporting. My installed EXCEL viewer does show
115 so Excel seems to be happy with the =DAYS(C4;B4) function. When
opened back by Calc, the D4 reads #MACRO? but the input line still
shows =DAYS(B4;C4), which is correct, so I think Walter has uncovered
a bug. If I place the cursor in the input line, make no changes, and
press enter, the cell D4 now reads 115. I am attaching a test
spreadsheet, "TAGE.XLS" which probably won't make it through the mail
list stripper process.
Using Excel 2003 - I got a #NAME? error on the macro. and 115 as the
answer doing +B5-C5
Excel 2007 shows same results as Bruce's. The closest formula that I can
find to match in Excel is Days360.
DAYS360(start_date,end_date,method) where method is a logical value that
specifies whether to use the U.S. or European method in the calculation.
--
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]
