age formula showing months

[Mel the Teacher]

I'm using the formula =IF(MONTH(TODAY())>MONTH(A1),YEAR
(TODAY())-YEAR(A1), IF(AND(MONTH(TODAY())=MONTH(A1),DAY
(TODAY())>=DAY(A1)), YEAR(TODAY())-YEAR(A1),(YEAR(TODAY
())-YEAR(A1))-1)) in a spreadsheet to calculate an age of
a student as at the date in cell A1.
The formula only shows the student's age in whole years.
How can I modify the formula and/or format the cells so
that the result shows age in years and months?
i.e. 14, 2/12 for someone who is 14 years and 2 months.
Please help?

 

[JE McGimpsey]

one way:

=TEXT(DATEDIF(A1,TODAY(),"y"),"0\, ") &
TEXT(DATEDIF(A1,TODAY(),"ym"),"0\/12")

For more on DATEDIF(), see

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

 

[Mel the Teacher]

Thank you for your help
that formula suits my needs perfectly.