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