calculating service dates

[Tanya]

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?

 

[Dave R.]

Do you want to do away with days and have some decimal after the month? Or
do you want to add these up?

 

[Peo Sjoblom]

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