Jack D. Lewis wrote:
Brian Barker wrote the following on 5/9/2008 3:55 PM:
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.
Brian Barker
I'm not sure how you can claim that this function is designed to give
the wrong answer. The answer given is the correct answer for the
number of days BETWEEN the two dates. Not the number of days between
the two dates plus a day for either the beginning date or ending date.
By the way, the OP is not subscribed. I have just realized this, so I
sent him the thread link
off-line so that he can read all the responses.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
