View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John K
 
Posts: n/a
Default Formula to compute someone's age if you enter their B-day

You can put today() in any cell ie a1 then put the date you want ie
02/17/1989 in say a2. Then in b2 put =year(a1)-year(a2). This will give you
the age. Be sure to make b2 or the cell the formulars in a number format.

John

"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.