I have a spreadsheet
that calculates the # number of weekdays that a client was enrolled in a program between an two dates. In my example, lets say the billing period is 9/1/13(b26) and 9/30/13(b27). I want to calculate the # of billable days that an individual was enrolled between those two dates. In row 31 you can see john doe enrolled in the program on 8/29/13. His end date is blank which means he is still enrolled. My formula correctly calculates that he should be billed for a total of 18 (e31) days. 18 is the number of days he was enrolled between 9/1 and 9/30 - holidays (named range is bethlehem).
Now to what I cant figure out. I have some clients that are enrolled part time. Lets say they should get billed for every Tuesday and Thursday, or every Mon, Wed, Fri. How can I apply the same formula as above, but instead of calculating all weekdays - holidays, i want to calculate all Tuesdays and Thursdays that a client was enrolled between two billing dates (-holidays).
Thank you very much for your help.