Thread
:
Excel functions
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Mike
external usenet poster
Posts: 3,101
Excel functions
Assumes DOB is in A1
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"
"Rodica" wrote:
What function should I use to calculate the age of a person?
Reply With Quote
Mike
View Public Profile
Find all posts by Mike