<div>
I think you would need VBA for that unless there is some new feature in 2013
</div>


<div>
To be able to get the value &quot;as displayed&quot; you can use a formula like this<br />
=DisplayedText(H9)<br />
<br />
and this UDF in the VBA window<br />
<br />
Function DisplayedText(rng as range)<br />
&nbsp; &nbsp; DisplayedText = rng.text<br />
end function<br />
<br />
To enter the UDF in VBA<br />
Right-click on the sheet tab name<br />
Select View code<br />
From the menu &nbsp; &nbsp; &nbsp;Insert &gt;&nbsp;Module<br />
Paste this code in the VBA window<br />
Close the VBA window<br />
Enter the function formula in excel.
</div>


<div>
Thank you for the quick and accurate assistance; it was most appreciative. Please excuse my delay in awarding the points.
</div>


<div>
<div class="content wysiwyg-content">
I have a list of Dates with the format: &nbsp;&quot;ddd - mmm dd, yyyy&quot;, which for example, displays as: &quot;Fri - Nov 01, 2013&quot; in the cell.<br />
<br />
What I would like to do is to create an IF formula in another cell that reports based off the displayed text from the described cells above. I've begun by utilizing the following formula: =IF((SEARCH(&quot;Fri&quot;,H9)),&quot;Ye<wbr />s&quot;, &quot;No&quot;). The problem is the text displayed in the cell may be, &quot;Fri - Nov 01, 2013, but in the formula bar it is listed as 11/1/2013. If the cell is placed in any other format, it displays as a number &quot;41579&quot;. How can I get the formula to search the cell (H9 in this case) for the text that is displayed, not the actual date or corresponding number associated with that date?
</div>
</div>


I have a list of Dates with the format:  "ddd - mmm dd, yyyy", which for example, displays as: "Fri - Nov 01, 2013" in the cell.

What I would like to do is to create an IF formula in another cell that reports based off the displayed text from the described cells above. I've begun by utilizing the following formula: =IF((SEARCH("Fri",H9)),"Yes", "No"). The problem is the text displayed in the cell may be, "Fri - Nov 01, 2013, but in the formula bar it is listed as 11/1/2013. If the cell is placed in any other format, it displays as a number "41579". How can I get the formula to search the cell (H9 in this case) for the text that is displayed, not the actual date or corresponding number associated with that date?

Reporting based off of displayed text in cell.

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.