If you actually have the text string "Sat" in C18:C382, then it should
work.

Make sure there are no spaces in preceding or after any text strings in
either column C or D.

How are the dates and the weekdays being entered or populated?


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=539818