Should work...Make sure you tell Find to look in formulas
--
Gary''s Student - gsnu200761


"JR Hester" wrote:

Excel XP on Win XP

I am using the following formula every 27th cell down a column to display
teh day of week.
=CHOOSE(WEEKDAY(B785),
"Sunday","Monday","Tuesday","Wednesday","Thursday" ,"Friday","Saturday")
The formula works great, problem is I want to be able to use the FIND
button/command to go to the next "Tuesday" qucikly. My find reports "No
MAtches Found". I presume this is because each cell contains a formula result
and not the actual TEXT "Tuesday". Is there a simply solution to my dilemmna?

Thanks to all