subtract years and months (as in ages) from another age

  • Thread starter Rumplestiltskin
  • Start date
R

Rumplestiltskin

How do I use excel to subtract one age from another, for example 11 years 5
months from 14 years 3 months?
 
B

Bob Phillips

Subtract the original cells from each other and convert in the same way that
you did for these two.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
N

Newbeetle

Hi on the cells you wish to enter the dates, select them, then right mouse
click and select Format cells.

Select custom from the list and type in yy"Years" mm"months"

If you want to see 11 Years 5 months in the cell you have applied the custom
format type 1/5/11
If you want to see 14 Years 3 Months, type in the other cell 1/3/14

In the cell you want the answer, apply the custom format the same as above,
then simply do =cell-other cell, ie so if you have date of 14Y 3M in cell A1
and 11y 5m in B1 in cell C1 type = a1-b1

Hope that helps
 
N

Newbeetle

Hi this is another way and should be more accurate as the other way I said
can be out by a month on certain dates.

A B C
D E
Cell1] Years Months Total Months
Cell2] 14 3 =(A2*12)+B2
Cell3] 11 5 =(A3*12)+B3
Cell4] =ROUNDDOWN(D4,0) =C4-(A4*12) =C2-C3 =C4/12

You can then format to look exactly as you want
 
Top