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

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

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