calculating service dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do you want to do away with days and have some decimal after the month? Or
do you want to add these up?
 
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
 
Back
Top