date functions:yearfrac

**diltselizabeth** · 10-06-2009, 01:04 PM

i need to find out the age of my students in years and months. can anyone help me with the calculation for excel 2007. i have tried 'yearfrac' against the DOB and todays date, but no luck - it gives me a percentage of 100 not 365. HELP!!!

**shg** · 10-06-2009, 01:05 PM

Welcome to the forum.

See http://www.cpearson.com/excel/datedif.aspx

**DonkeyOte** · 10-22-2009, 05:25 AM

Given your duplicate post I'm assuming you're still having issues implementing the DOB approach outlined in the link provided previously by shg ?

In essence

=DATEDIF(A1,TODAY(),"y")&" Year(s) and "&DATEDIF(A1,TODAY(),"ym")&" Month(s)"

where A1 holds d.o.b

**daddylonglegs** · 10-22-2009, 06:48 AM

At one time at least there were some bugs with DATEDIF in Excel 2007. Here's a workaround that doesn't use DATEDIF

=YEAR(TODAY())-YEAR(A1)-(TEXT(TODAY(),"mmdd")< TEXT(A1,"mmdd"))&" years "&MOD(MONTH(TODAY())-MONTH(A1)-(DAY(TODAY())< DAY(A1)),12)&" months"