To just extract the year they were born use =YEAR("08/14/1951")

--
Regards,
Dave


"Stephanie" wrote:

can anyone give me the answer to the above? I have an employee census which
I need to figure out the average age of 200 employees. The dates of borth
are shown as month, date and year.................