Prev: Formatting Text to Numbers for Dates
Next: Conditional Format - How to View???
From: Mike on 27 May 2010 16:35
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
 | 
Pages: 1
Prev: Formatting Text to Numbers for Dates
Next: Conditional Format - How to View???