calculate end date using start date and number of specific weekdays

Hello,

I am teaching a class that requires students to attend a total of 24 times - classes are held on mondays and wednesdays.

What I want to do is input the student's start date and have a formula return an end date based on that student attending 24 classes.

I want to have several cells in the excel sheet for each student - example:
A1 = Start Date
B1 = 24 (number of classes they have to attend)
C1 = number of classes they have attended
D1 = SUM(B1-C1) = number of classes remaining
E1 = End date based on cell D1

The information in E1 would need to update itself based on the information in D1 - leaving me the ability to change the data in C1 each time the student is present for class.

I realize this is a bit complicated - i'm just totally lost on how to lay this out...

So far I've been able to come up with the following code to determine the number of Mondays and Wednesdays between two specific dates, but that's not exactly what I'm after.

Please Login or Register  to view this content.

Any help would be so greatly appreciated!
Thank you

x-thread here for reference:

http://www.mrexcel.com/forum/showthread.php?t=352845