=YEAR(A1)

where A1 holds the date

--
Regards,

Peo Sjoblom

(No private emails please)


"Althea" wrote in message
...
Hi
Need to get year of a date entry into a separate column, whats the
formula?
eg 2/5/1900..want 1900 in separte column

Thanks
Althea