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


--
This post was created using recycled electrons!


"Rumplestiltskin" wrote:

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