You have that already, looking at that table how would you display the correct
number of months and years in let's say line 2?
You have 4 years and 2 months, if you want it in the same cell with a space
between number and years/months you can use

=SUBSTITUTE(A1,"years"," years")&" and "&SUBSTITUTE(B1,"months"," months")

Regards,

Peo Sjoblom
"Tanya" wrote:

I have the formula to calcuate date ranges which are returned in the
following format:
0years 4months 9days
4years 2months 15days
0years 5months 16days
28years 8months 30days

Now, how do I create a formula to calculate this information to correctly
reflect the number of months and years?