MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pupil's ages

Posted by john farrell on June 14, 2001 3:59 AM

Can anyone point me to a formula that will give me a child's age [i.e. 14:11 would be 14 yrs 11 months] in either a numeric style [14:11] or, better still [14 years 11 months]
Many thanks

Posted by Dax on June 14, 2001 4:10 AM


If you format the cell with the date formula like this:- (choose Format,Cells,Custom) you'll get what you're after.

yy "years and" mm "months"


Posted by Aladin Akyurek on June 14, 2001 6:33 AM


=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months"