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
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.