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

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

[Stephanie]

Dave: Thanks!!

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

[Stephanie]

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

[Ron Rosenfeld]

On Wed, 7 Sep 2005 08:51:11 -0700, Stephanie
<[email protected]> 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

[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

"Ron Rosenfeld" wrote:

> On Wed, 7 Sep 2005 08:51:11 -0700, Stephanie
> <[email protected]> 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
>