C
Candentco Creative Collection
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
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