Try this with the earlier date in A1

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months
"&DATEDIF(A1,B1,"md")&" days"

For an explanation of datedif look here
http://www.cpearson.com/excel/datedif.aspx

and for the occasions when it can go wrong look here
http://www.microsoft.com/office/comm...23f&sloc=en-us

Mike

"Naveeddil" wrote:

Hello
Let's Suppose i gave some date 01-01-2007 in cell A1 and 01-05-2010 in cell b1

if i Subtract Cell B1 from A1 so the Answer will be 1100 Days BUT

i want these days as date like 6 days 1 months and 3 Years

OR

01/06/03


Is it Possible ?
Please Help