You can calculate a persons age based on their birthday and todays date. The calculation uses the DATEDIF() function.
Birth date : 29-Apr-73
Years lived : 41 =DATEDIF(C8,TODAY(),"y")
and the months : 10 =DATEDIF(C8,TODAY(),"ym")
and the days : 23 =DATEDIF(C8,TODAY(),"md")
You can put this all together in one calculation, which creates a text version.
Age is 41 Years, 10 Months and 23 Days
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"
Another way to calculate age
This method gives you an age which may potentially have decimal places representing the months.
If the age is 20.5, the .5 represents 6 months.
Birth date : 1-Jan-60
Age is : 55.23 =(TODAY()-C23)/365.25