DATEDIF function not working for YD in EXCEL2007?

=DATEDIF(A18,$A$25,"YD")

Using the above formula if I enter the 15th July 1991 into cell a18 and the 25th June 2007 in cell a25 the formula returns the answer 189.

This is not the correct answer it should I think be 345.

I have used this formula many times and it has always worked and whilst it still does for most dates it now does not work with others. I have recently updated to excel 2007.

Is there a problem with this function in 2007?

Originally Posted by Quaisne

=DATEDIF(A18,$A$25,"YD")

Using the above formula if I enter the 15th July 1991 into cell a18 and the 25th June 2007 in cell a25 the formula returns the answer 189.

This is not the correct answer it should I think be 345.

I have used this formula many times and it has always worked and whilst it still does for most dates it now does not work with others. I have recently updated to excel 2007.

Is there a problem with this function in 2007?

Designed flaw in XL-2007. Use older version instead. The correct answere should be 346

Originally Posted by oldchippy

If you format A18 to number, you should have 33434 and similarly with A25 that should be 39258.

A25-A18 = 346

A25-A18 = 346 (WRONG)

Originally Posted by Teethless mama

Designed flaw in XL-2007. Use older version instead. The correct answere should be 346

I tried this for myself, seems weird, what's the deal, O Toothless One? Is this documented anywhere?

Well that is a blow it is a formula I use frequently. Any suggestions for a substitute?