DAYS360
 

I have two date columns for which the difference between them is used for
several subsequent calculations. My problem is when I use DAYS360, the
result is not consistent, i.e.:

Column A Column B Result of DAYS360 function

05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
months)
05/01/2007 2/29/2008 298.0
or
1/1/2005 12/31/2005 360
12/1/2004 11/30/2005 359

So:

(1) Why does not Excel return 10 or 300 in the first example and 360 on the
last line of the second example or

(2) Does anyone have a another solution?

Many, many thanks!



--MVD
San Francisco, California

DAYS360
 

If you need the number of days between two dates, just subtract one from the other and format as number.
DAYS360 is used in certain areas of finance and insurance and has its own set of rules (two sets, actually), which are explained
in HELP.
Unless you explicitly require the 360-day system, don't use DAYS360.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Candentco Creative Collection" .com wrote in message
...
|I have two date columns for which the difference between them is used for
| several subsequent calculations. My problem is when I use DAYS360, the
| result is not consistent, i.e.:
|
| Column A Column B Result of DAYS360 function
|
| 05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
| months)
| 05/01/2007 2/29/2008 298.0
| or
| 1/1/2005 12/31/2005 360
| 12/1/2004 11/30/2005 359
|
| So:
|
| (1) Why does not Excel return 10 or 300 in the first example and 360 on the
| last line of the second example or
|
| (2) Does anyone have a another solution?
|
| Many, many thanks!
|
|
|
| --MVD
| San Francisco, California

DAYS360
 

Thanks. I had considered that but was attempting to use a more "smoother"
approach since the calculations that feed from this result deal with monthlty
rent that is constant each month. However, I will improvise and thanks again
for your time and assistance.

Regards,
--
MVD
San Francisco, California


"Niek Otten" wrote:

If you need the number of days between two dates, just subtract one from the other and format as number.
DAYS360 is used in certain areas of finance and insurance and has its own set of rules (two sets, actually), which are explained
in HELP.
Unless you explicitly require the 360-day system, don't use DAYS360.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Candentco Creative Collection" .com wrote in message
...
|I have two date columns for which the difference between them is used for
| several subsequent calculations. My problem is when I use DAYS360, the
| result is not consistent, i.e.:
|
| Column A Column B Result of DAYS360 function
|
| 05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
| months)
| 05/01/2007 2/29/2008 298.0
| or
| 1/1/2005 12/31/2005 360
| 12/1/2004 11/30/2005 359
|
| So:
|
| (1) Why does not Excel return 10 or 300 in the first example and 360 on the
| last line of the second example or
|
| (2) Does anyone have a another solution?
|
| Many, many thanks!
|
|
|
| --MVD
| San Francisco, California

DAYS360
 

Try playing around with something like the following.

=((Year(enddate) - Year(startdate))*12) + (Month(enddate) -
Month(startdate)) & " months & " & (Day(enddate) - Day(startdate)) & " days."

It will give you the number of months and days between the 2 dates. The
issue you are going to have is that the "day" of the month can be different
(end of month is 28, 29, 30, or 31 days). If you can ensure that this is
just full months then you can modify the forumla a little.

HTH

"Candentco Creative Collection" wrote:

I have two date columns for which the difference between them is used for
several subsequent calculations. My problem is when I use DAYS360, the
result is not consistent, i.e.:

Column A Column B Result of DAYS360 function

05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
months)
05/01/2007 2/29/2008 298.0
or
1/1/2005 12/31/2005 360
12/1/2004 11/30/2005 359

So:

(1) Why does not Excel return 10 or 300 in the first example and 360 on the
last line of the second example or

(2) Does anyone have a another solution?

Many, many thanks!



--MVD
San Francisco, California

DAYS360
 

Hey, thanks alot. Will play with it and see what shakes out. Have a good one!

--
MVD
San Francisco, California


"William Horton" wrote:

Try playing around with something like the following.

=((Year(enddate) - Year(startdate))*12) + (Month(enddate) -
Month(startdate)) & " months & " & (Day(enddate) - Day(startdate)) & " days."

It will give you the number of months and days between the 2 dates. The
issue you are going to have is that the "day" of the month can be different
(end of month is 28, 29, 30, or 31 days). If you can ensure that this is
just full months then you can modify the forumla a little.

HTH

"Candentco Creative Collection" wrote:

I have two date columns for which the difference between them is used for
several subsequent calculations. My problem is when I use DAYS360, the
result is not consistent, i.e.:

Column A Column B Result of DAYS360 function

05/01/2007 2/29/2008 9.9 (if I divide by 30 to convert to
months)
05/01/2007 2/29/2008 298.0
or
1/1/2005 12/31/2005 360
12/1/2004 11/30/2005 359

So:

(1) Why does not Excel return 10 or 300 in the first example and 360 on the
last line of the second example or

(2) Does anyone have a another solution?

Many, many thanks!



--MVD
San Francisco, California