I am attempting to build a schedule for a class. I have a column with the course name, number of hours the class runs for, the start date of the class and the end date of the class.

I am attempting to create a formula in which I can feed the start date, and number of hours the class is to produce the end date of the class as output.

In the past I have used the WORKDAY function and it works flawlessly. However, this course has an odd schedule. Mondays and Tuesdays are 8.5 hours, and Wednesdays are 8 hours. The hours each class runs for are not necessarily divisible by these days either so there will be partial days. This can simply be rounded to the next day.

SOO ... is there a formula or macro that can take a start date, run through the calendar adding up the varying hours until the minimum number of hours for the course have been reached? I also need a way to exclude days just like with the WORKDAY function.

Any assistance is greatly appreciated!