DATEDIF is not used much since it was not really visible in most versions of
Excel (Nothing on it in Help or "Insert function" dialog)...
--
Festina Lente


"Dave F" wrote:

I can't believe I'm the first person to have experienced this.
--
Brevity is the soul of wit.


"PapaDos" wrote:

A bug report to Microsoft would be a good idea...
--
Festina Lente


"PapaDos" wrote:

Maybe by adding a day to the latest date ?
Or using a combination of MONTH() and YEAR()...

DATEDIF() will return the difference in "full month", but who knows what it
means exactly...
--
Festina Lente


"Dave F" wrote:

Here's the formula:

=IF(I$6<$G14,"",IF($F14<0,"N/A",IF(DATEDIF($G14,I$6,"m")/$B$3*$F14$F14,"",DATEDIF($G14,I$6,"m")/$B$3*$F14)))

I6 is 4/30/2006, G14 is 3/31/2006, F14 is $85,968, B3 is 48

I think it should resolve to 1/48*$85,968 = $1,791. But excel is
calculating it as $0.00.

Thoughts?

--
Brevity is the soul of wit.