Thread: Formula to compute someone's age if you enter their B-day
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Formula to compute someone's age if you enter their B-day
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"


if the birthday is in A1
--
Gary's Student


"Millerk" wrote:

I'm trying to find out the formula that will allow someone to enter a child's
birthday in one cell and another cell will compute their age.
Reply With QuoteReply With Quote