Different Between Two Dates Returning Number of Years, Months, Days

[gymwrecker]

Need help with the following:

I have the following two dates.

A1=20090930
B1=20200531

I need the formula to return the following in C1: "XX Years, XX Months, XX Days".

Note: I searched the forum and couldn't find a formula for this.

 

[Fluff]

but it's not working for me as a1/b1 aren't date formats

In post#2 davesexcel asked if they were dates, to which the OP replied yes.
Also if you put real dates in A1 & B1 you will get the same result the OP reported in post#5

 

[gymwrecker]

How about

=DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"ym")&" Months "&DATEDIF(A1,B1,"md")&" Days"

After I formatted A1 and B1 as "DATE", copied your formula and it worked! Thank you all for your help!!!

 

[Fluff]

Glad we could help & thanks for the feedback.