I suggest that you check again. To start with, you should format your
DATEDIF output cell as General or Number, not as a date, but if you're
getting 2/18/06 that would be equivalent to a number of 2241 if the 2/18/06
were 2/18/1906, or 38766 if it were 2/18/2006, so I don't see how you're
getting that from a DATEDIF in years whose finishing point is TODAY(). What
value do you have in E5 (firstly as a date, but secondly if you reformat it
temporarily to Number or General)?
--
David Biddulph

"George" wrote in message
...
Thanks Papou, but this does not work, it sends back a date, (such as
2/18/06), but i am looking for the difference in years, (46)

"papou" wrote:

Hello George

=DATEDIF(E5,TODAY(),"Y")

"George" a écrit dans le message de
news:
...
=DATEDIF(E5,TODAY(),"Y") & " Years "
i have used this formula, but i do not want the word years to show up
in
the
cell, how do i modify it.

"Franz Verga" wrote:

Deborah wrote:
I used the following formula to calculate the difference between two
dates:

=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"

01/01/2006 28/02/2006 0 years, 1 months, 27 days
01/01/2006 31/01/2006 0 years, 0 months, 30 days

Which is ok but I would want the result for the first example to be
2
months and for the second example 1 month.

Should I use another formula?

Thanks in advance
Deborah

Hi Deborah,

try with this modified formula:

=DATEDIF(A2,B2+1,"y") & " years, " & DATEDIF(A2,B2+1,"ym") & " months,
"&DATEDIF(A2,B2+1,"md") & " days"



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy