ExcelBanter - How do I calculate a persons age from birth dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I calculate a persons age from birth dates (https://www.excelbanter.com/excel-discussion-misc-queries/264564-re-how-do-i-calculate-persons-age-birth-dates.html)

Mike

How do I calculate a persons age from birth dates

this will do age Put your birthday in cell A1 and test
=DATEDIF(A1,TODAY(),"Y") & " Years old "

this will do years months and days
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

"Rod Bishop" wrote:

Wanting a formula to calculate a persons age from birth to today's date

All times are GMT +1. The time now is 05:33 PM.