Avatar of brianpowell
Flag for United States of America

asked on 

text field ms excel


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

Microsoft Excel

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon