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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks