Project Scheduling, Include Weekends, Exclude Holidays...Arghhh...

[mlib27]

Hi...thank you all for what you do here...tremendous help to the rest of us! Anyway, I'm trying to create a project schedule for the renovation of certain parts of a building. The workdays are slated to be Saturdays, Sundays, Mondays, & Tuesdays only. However, on occasion there's a holiday on a Sat, Sun, Mon, or Tues. The information I have is a start date and an estimated number of days required for each renovation area.

So...clearly the workday function is out...looking at my current worksheet, I'm setup as the following...

D20: Quantity of work days required
E20: Start Date (03/19/2011)
F20: Finish Date (this would be start date + D20)

J19:J173: this is a list of all dates that are not work dates, mostly Wednesdays, Thursdays, Fridays, but it also includes some other days such as Mondays that are holidays, etc.

So...what I really really need is a formula for F20 that calculates the end date, but knows that the stuff in J19:J173 are not available as work dates...any ideas????

Thank you!

 

[mlib27]

Thanks again Barry...

I was trying to create a couple worksheets with the formulas...ran into an issue...

On the 1st crew, they are working only Sat, Sun, Mon, Tues, unless there's a holiday/off-day, formula seems to be working great...

But we have a 2nd crew, which will be working only Sat & Sun....I've already created the list of holidays/off-days, which lists every weekday and then a bunch of various Saturdays & Sundays that would be holidays/off-days, but the formula seems to be counting Monday & Tuesday as work days...I'm pretty sure the formula knows what days to use, so maybe a slight tweak for this crew so that the formula knows to only use Sat/Sun as workdays?

Thanks again...huge huge help...I'm getting better w/Excel! Sloooowwwwlllllyyyyy...but surely!

Best,

Matt