software

Hi,

I'm puzzled why Excel 2003 gives a difference in days as quot;-2quot; when using Feb
28th as the start and end date.

I have the following dates in two columns (quot;Hquot; and quot;Iquot;) 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 quot;-2quot;... If I just change the date to 28.03.2006
for both, it works ok, resulting in quot;0quot;. The formula is working on this
sheet on every other occasion except on these quot;double-28.02.2006quot; dates.. I
even tried adding the quot;truequot; or quot;falsequot; methods after the formula, but no
help.

Can anyone help and/or clarify why this is so?

thanks in advance,
-pjt

You are using this function in a way that it was not designed to be
used.

Days360(StartDate, EndDate) returns the number of days between
StartDate and EndDate based on a 360-day year (i.e., all months contain
30 days). If EndDate is earlier than StartDate, NumDays is negative.--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=518141
Also if the month in question is over 30 or under 30 excel treats it as
30 so that is why you are getting the -2.--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=518141=A1-B1 returns the difference in days. Just Format as General or Number;
Excel will automatically format as date, which is pretty stupid in this
case!

360 days years are often used in financial calculations; they assume a year
of 12 months of 30 days. This avoids many difficult definition issues for
months.

--
Kind regards,

Niek Otten

quot;Petteri Tuominenquot; gt; wrote in message
...
gt; Hi,
gt; thanks for the explanation, although I can't understand the benefits of
gt; using quot;artificialquot; months (i.e. all with 30 days)... Or is the 365-way
gt; impossible to code in the sw?
gt;
gt; Is there a way to calculate the days as they appear in the real world?
gt;
gt; No quot;Days 365quot; -function exists.. ;-)
gt;
gt; -pjt
gt;
gt;
gt; quot;intruder9quot; gt; wrote
gt; in message ...
gt;gt;
gt;gt; Also if the month in question is over 30 or under 30 excel treats it as
gt;gt; 30 so that is why you are getting the -2.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; intruder9
gt;gt; ------------------------------------------------------------------------
gt;gt; intruder9's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30107
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=518141
gt;gt;
gt;
gt;
Hi,
thanks for the explanation, although I can't understand the benefits of
using quot;artificialquot; months (i.e. all with 30 days)... Or is the 365-way
impossible to code in the sw?

Is there a way to calculate the days as they appear in the real world?

No quot;Days 365quot; -function exists.. ;-)

-pjtquot;intruder9quot; gt; wrote
in message ...
gt;
gt; Also if the month in question is over 30 or under 30 excel treats it as
gt; 30 so that is why you are getting the -2.
gt;
gt;
gt; --
gt; intruder9
gt; ------------------------------------------------------------------------
gt; intruder9's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30107
gt; View this thread: www.excelforum.com/showthread...hreadid=518141
gt;