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.