If the data is in A1 then in B1 you could type =Year(a1) or

in B1 type =A1, then choose Format, Cells, Number, Custom and in the Type
box type yyyy

The first method extracts the Year while the second retains the value and
changes the appearance of the date.

Peter

"PAL" wrote:

I have a date (any format, includes m/d/y) in one cell. In the cell next to
it, I just want the year to appear. Doesn't seem to be a format to allow
that. Please advise.