Should be 9.

It is time to review.
http://www.cpearson.com/excel/datedif.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Haddox" wrote:

Looking through various forums, I see that the DATEDIF function can be a bit
buggy at times, particularly w/respect to "md" interval type and in Excel
2007.

So I just wanted to see if folks could replicate these strange results in
2007, and perhaps confirm this is indeed a bug:

=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. In 2002,
however, it gives me the correct answer of 9. Have not tried it in 2003 yet.

Appreciate any responses. Thanks.