On Wed, 7 Sep 2005 08:51:11 -0700, Stephanie
wrote:

I tried that, got the date of 5/14/1905????

"David Billigmeier" wrote:

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

Format your cell as General or Number


--ron