I actually had the days spelled out but I changed it and your cod
works. I tried to expand it to 8-ddd... for the full name of the da
but it errored. If you know how to use the full day name please pass i
on and I will use it. If not, thanks for what you gave me.

Scoob

--
scoobydoo200
-----------------------------------------------------------------------
scoobydoo2006's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=56130