I have a spreadsheet that contains start dates and end dates for each record. some end dates are blank if the record is still active. Im looking for a way to calculate the number of weekdays, minus holidays, a client was enrolled in a class.
For instance, a17 - d17 shows that shows that john was enrolled from 8/29/13 - 10/11/13. I want to run a report that shows me the total # of workdays (- holidays) that John was enrolled between 9/1/13 and 9/30/13.
In another example, a18 - d18 shows that Jim was enrolled from 8/26/13 and is still enrolled because they do not have an end date. I want to calculate the number of work days (- holidays) between 9/1/13 and 9/30/13. You should assume that the client is still enrolled because there is no end date.
you can see that in H11 i used the networkdays function in an attempt to solve my problem, but that didnt work exactly as i needed.
see this spreadsheet
thank you for your help.