The answer you got is entirely correct.

What did you expect and why?

--
Kind regards,

Niek Otten

"DKY" wrote in message
...

I've just noticed a problem. I've got this

Code:
--------------------
=DATEDIF(A6,TODAY(),"Y")
--------------------

The value in cell A6 is 8/18/1995 and for some reason It keeps giving
me 10 for the years. I checked the output of TODAY() and it gives me
the following 02/20/06, which is today's date so I can't figure out why
this thing is giving me the number 10.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=498255