Hi

with your date in a1
put this in b1
=A1 and a custom format of yyyy


Mike

"Pam" wrote:

Hi,

I found a post that gave year function (=year(cell)) to extract only the
year from a date. I have 1/15/2006 and I get 6/28/1905. This date was
exported from Access into an Excel spreadsheet. I'm not sure if that would
have an effect on it, but thought I would include it in message. If I
format the new column to a number, I get 38722. I know Access uses numbers
for dates, so I need to somehow convert to get correct year.

Can anyone help me get 2006 from 1/15/2006?

Thanks in advance for any help,
Pam