Thread: Excel functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?