How can I format cells to show ages in years and months eg"12:05".

D

David F

The cells keep thinking that I want to show hours:minutes;secs?
I have tried Yy:Mm and [Yy]:Mm but without success.
 
B

Bernie Deitrick

David,

Format the cell as Fraction, up to tow digits, and enter your value like

12 5/12

There really isn't a standard for years and months being entered into a
single cell and displayed.

HTH,
Bernie
MS Excel MVP
 
M

mzehr

Hi,
Try also the following, if formatting will not work, and
you are already having to do a calculation to derive the
individual's age:

=DATEDIF(A1,NOW(),"y") & ":" & DATEDIF(A1,NOW(),"ym")

Unfortunately you will not be able to easily do additional
calculations based on the results.

See Chip Pearson's website for more info:

http://www.cpearson.com/excel/datedif.htm

HTH
 
Top