I dont understand. How would I edit

=IF(D2="M","Monday",IF(D2="T","Tuesday",IF(D2="W", "Wednesday",IF(D2="R","Thursday","Friday"))))

so that the logical test part (the first one being D2="M") can be

D2{contains}"T M"

?

I want to replace D2="M" with D2{contains}"T M", but I just do not know
how to notate this.

Thank you so much though for your time.

:)


--
brookdale
------------------------------------------------------------------------
brookdale's Profile: http://www.excelforum.com/member.php...o&userid=24617
View this thread: http://www.excelforum.com/showthread...hreadid=382076