what is the formula to change 08/14/51 into 1951?

[Stephanie]

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

 

[David Billigmeier]

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

 

[Stephanie]

Dave: Thanks!!

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

 

[Stephanie]

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

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

 

[Ron Rosenfeld]

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

Format your cell as General or Number


--ron

 

[Stephanie]

thanks Ron, that worked. But when I copy the formula down the column, it's
not picking up the new dates of birth, only the original. Tried using F4,
but that doesn't work on this formula for some reason.............. any hints?
Thanks again