On Thu, 27 Aug 2009 04:19:07 -0700, "JoeU2004" wrote:

"Ron Rosenfeld" wrote:
Caveat emptor: Some MVPs have indicated that DATEDIF
is broken in some updates of Excel 2007. I don't know
anything about that.

It seems to be broken in Excel 2007 SP2+, at least with
regard to the "md" parameter.

Wunnerful! How is it broken? Results in an error? Or bad numbers?

If the latter, are the numbers always bad? Or just certain cases?

Can you post some examples?

Just curious....

from:

http://groups.google.com/group/micro...669af5100 b56


=DATEDIF(DATE(2009,6,27),DATE(2012,1,5),"md")

In 2007, this gives me 122. This happens all the way up to the point where
the second date is 1/26/2012 and then it hits zero at 1/27/2012.


And it is the case on my Excel 2007 SP2 also
--ron