On Wed, 29 Jun 2005 22:59:45 +0200, "DzEK" wrote:

want to calculate the difference between two dates
and necesarry to see the result separated by years / months / days
but dont know how??

for example: 20/05/2005 - 10/03/1990 = 15 years/ 2months/ 11days

thanks for your attention!!


PS using excel 2000

Since all months and years do not have the same number of days, you will have
to accept some approximations, or else define exactly what you mean by a
"month" and a "year".

Take a look at the DATEDIF function. I believe Excel 2000 may be the only
Excel version in which it is documented. But see also
http://www.cpearson.com/excel/datedif.htm


--ron