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

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

Guest

How do I use excel to subtract one age from another, for example 11 years 5
months from 14 years 3 months?
 
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)
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top