This may not be the *best* way, but it looks like it works ...

In A1 put Date1 (eg 19 Feb 1999)
In A2 put Date2 (eg 07 Jan 2005)
In B1 put the formula =INT(YEARFRAC(A1,A2,1))
In B2 put the formula =INT((YEARFRAC(A1,A2,1)-B1)*12)
In B3 put the formula =A2-DATE(YEAR(A1)+B1,MONTH(A1)+B2,DAY(A1))
In C1 put the text "Years"
In C2 put the text "Months"
In C3 put the text "Days"

If you need to get the result all into one cell, you can make a
compound formula, or concatenate the results as you wish.

HTH
ScottO

"ady_sandu" wrote in message
...
| How do I calculate the difference between 2 dates (m,d,y) ?
| For example :
| date1 = 19 feb 1999
| date2 = 07 ian 2005
| difference = **days, **months, **years.
| thank you!