Convert day, month, year, and time to just year

[bam]

Hello, what formula can I use to convert day, month, year, and time values
to just a year

For example, what formula can I use to convert 4/16/2002 12:59pm to simply
2002 or 1/1/2002.

bmac

 

[Bob Phillips]

=YEAR(A1)

or just format the cell as YYYY to se ethe year but retain the value

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bam]

Thasnks for responding ... I still must be doing something wrong ...

In E2 I have the date 6/20/2001 12:25pm and then enter in H2 ... =YEAR(E2)
and I get the value 6/23/1905.

Any ideas?

 

[Dave Peterson]

Format it as General (or number)--just not a date.

 

[bam]

Thanks very much!

Format it as General (or number)--just not a date.

 

[Bob Phillips]

I'm just your patsy aren't I? I lead with a half-volley, and you smash the
winner <g>

Do you play tennis?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

Maybe you can lead the league in assists!

I'm just your patsy aren't I? I lead with a half-volley, and you smash the
winner <g>

Do you play tennis?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)