Search dates in column A and return 'year' in column B

Hi,
Given a column containing dates (formatted as dd/mm/yy), how can i get excel to examine these and return the year in another column?

e.g., if column A has:
01/02/05
06/04/07
and so on another 17 thousand times...

how can i output in column B (i.e. as a number):
2005
2006
and so on....

Thanks in advance

Hi
place this code in module
and use rt function it will work for u

pankaj kaushik


Function rt(t As Date)
rt = Year(t)

End Function

Alternatively you can use the YEAR function provided with XL.
(BTW XL as a search function accessed with F1 with which you can find lots of info)
Cheers

If it is just for display purposes then you could simply have (in B1 for eg):

=A1

and format the B column via Format>Cells>Number Tab>Custom

yyyy

Thanks to all who answered.

"=Year(A2)" was exactly what I needed

Cheers

Incidentally, when I try "=MONTH" excel gives me "January" for the date 03 July 2003

cheers mate