You seem to have replied to your own message, rather than to the person to
whom you are trying to reply, and you haven't told us what formula you tried
that didn't work, and you've also not told us in what way it didn't work.
Did it give an error message? Did it give what you thought was the wrong
result? If so, what result did you expect & what did you get?

One of the formulae which was suggested was
=datedif(sum(q18:t18);sum(q19:t19);"y") & ....
Did you try that? If so, what result did you get?
For me it gave 5 years 4 months 14days? What result did you want, and why?
--
David Biddulph


"Delya" wrote in message
...

The formula you both gave did not work.. Here is the exact sample what
i need
Column A Column B Column C
18.11.1992 13.09.1995 26.12.1996
20.09.1995 01.11.1996 22.05.1998
2years 10 Months 2 days 1years 1 Months 19 days 1years 4 Months 26
days
now I want to sum up the years (e.g.2 years 10 month 2 days) that given
below of each column. Any ideas?
--
Delya

Delya;658519 Wrote:

Hi,
I need to calculate work experience in years ,months, days. I did a
formula
=DATEDIF(Q18;Q19;"y")&" years "&DATEDIF(Q18;Q19;"ym")&" months
"&DATEDIF(Q18;Q19;"md")& "days", where Q18 is 03.09.2007 and Q19 is
05.07.2008. I got a result 0 years 10 months and 2 days. I now want to
add up
several such results in order to have total years , months and days,
how can
i do it?