I am trying to have the dates of the business days for the NEXT week b
generated based on today's current date.

So today is 6/30/05, and next weeks business days a
M - none(holiday
T - 7/5/05
w - 7/6/05
TH- 7/7/05
F- 7/8/05

This would be pasted in 5 cells vertially and the dates would onl
change the first day of the workweek. So if i came on on Tuesday i
would give me next weeks dates.

Would the easiest thing to do just create static data and have
vloookup or create a formula?

I just need to be able to come in every monday and see the dates of th
next weeks. I tried it using EOMonth function with no luck. Any help i
appreciated. Thanks

--
dstoc
-----------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...fo&userid=2422
View this thread: http://www.excelforum.com/showthread.php?threadid=38354