Appreciate it. I actually started there. The problem, as originally stated,
is that it is resulting in 122 in Excel 2007, but apparently not in other
versions.
"Jacob Skaria" wrote:
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.