extracting year from a date

G

grendel

i have a standard date of 9/1/06 and am trying to isolate the year in another
column. i have used
text(right(a2,2),"yy")), but am getting incorrect years. i have also tried
datevalue(right(a2,2)) and keep getting value errors.
 
C

CLR

If your date is actually TEXT, then.....
=RIGHT(A1,2)
or
=20&RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3
 
Top