<div>
ill try it thanks... was thinking in terms of instr.....
</div>


ill try it thanks... was thinking in terms of instr.....

<div>
what does the formatting for A1 need to be: &nbsp;<br />
<br />
bp
</div>


what does the formatting for A1 need to be:  

bp

<div>
If the date is text =YEAR(DATEVALUE(A1))
</div>


<div>
<div class="content wysiwyg-content">
q:<br />
<br />
I want the last 4 char of a date field in ms excel.<br />
<br />
e.g. 1/1/2012 &nbsp;returns 2012. &nbsp;or 01/1/2012 returns 2012.<br />
<br />
<br />
restated I want to extract the year from my date field without code.<br />
<br />
can anyone help<br />
<br />
thanks!
</div>
</div>


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!

text field  ms excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.