You can calculate a persons age based on their birthday and todays date.
The calculation uses the DATEDIF() function.
The DATEDIF() is not documented in Excel 5, 7, but it is in 2000.
Birth date : 15-Jan-96
Years lived : 26 =DATEDIF(C8,TODAY(),"y")
and the months : 5 =DATEDIF(C8,TODAY(),"ym")
and the days : 5 =DATEDIF(C8,TODAY(),"md")
Download Excel File For Practice
