Reporting based off of displayed text in cell.
Posted on 2013-12-01
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?