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!
LVL 1
brianpowellAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tomfarrarConnect With a Mentor Commented:
=year(A1).  A1 being the cell the date is in.
0
 
brianpowellAuthor Commented:
ill try it thanks... was thinking in terms of instr.....
0
 
brianpowellAuthor Commented:
what does the formatting for A1 need to be:  

bp
0
 
brianpowellAuthor Commented:
thanks!
0
 
tomfarrarCommented:
If the date is text =YEAR(DATEVALUE(A1))
0
All Courses

From novice to tech pro — start learning today.