Barry --

If the initial date is in A1, you can use

=WORKDAY(A1,1)

to get the next work day. The function allows you to set up a range of
holiday dates, and bypass those as well as weekends.

HTH

"Barry Clark" wrote:


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