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