View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default how do i calculate age in term of years, months, days

put =TODAY() in A1
put your birthday in B1
and put

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " &
DATEDIF(B1,A1,"md") & " days"

in C1
--
Gary''s Student


"shan" wrote:

how do i calculate age in term of years, months, days