Avatar of brianpowell
brianpowell
Flag for United States of America

asked on 

text field ms excel

q:

I want the last 4 char of a date field in ms excel.

e.g. 1/1/2012  returns 2012.  or 01/1/2012 returns 2012.


restated I want to extract the year from my date field without code.

can anyone help

thanks!
Microsoft Excel

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon