Calculate YYMMDD between two dates + format

[kcompton]

Hello, I would like to calculate the years, months, and days between two dates:
A2 = 5/6/2001
A1 = 8/26/2009

and return the value as XX years, xx months, xx days

I can get the difference yymmdd in the 01/10/07 format, but want to see it as
1 year, 10 months, 7 days.

Thank you for your help

 

[barry houdini]

Try using DATEDIF function, i.e.

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

 

[kcompton]

Thank you!

 

[VoG]

Try

=DATEDIF(A1,B1,"Y")&" y "&DATEDIF(A1,B1,"ym")&" m "&DATEDIF(A1,B1,"md")&" d"