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

So today is 6/30/05, and next weeks business days are:
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 only change the first day of the workweek. So if i came on on Tuesday it would give me next weeks dates.

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

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