Hello all.

I tried search and was not able to find what I was looking for.

This is what I am trying to do:

Have time sheets and they are kind of a bear.

I have the date column formatted to read -Weekday, Month Day, Year-.

Now, lets say that I enter -Friday, June 9, 2006- at the source cell.

In a following cell, I want it to evaluate the source cell for the
weekday only. That way, I can instruct the cell to take an action if
the entered weekday is Monday as opposed Friday.

Any thoughts? I am just overlooking something way too simple?

Thanks a bunch!

-Barry


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409