How to deduct holidays and take multiple projects into account in a report

Hi,

I recently asked about how to generate monthly and quarterly reports here: http://www.excelforum.com/excel-gene...ml#post2037946

I have now discovered that there are some problems with the validity of the "Nbr of Days worked", as it does not take into account holidays and if multiple projects are being worked on. So, if someone worked on the following:

Project A (20th December - 31st December)
Project B (1st January - 31st January)
Project C (1st January - 15th January)

This would be 8 + 22 + 11 networkdays, giving a total of 41 days. The thing is, as you can see, only 30 networkdays were actually worked upon. Then, if we take into account possible vacation days, it could be lower still.

Therefore, I need to work out a way of doing the following:

(1) Account for this overlap with the projects
(2) Be able to deduce holidays (assuming the data is provided in the file that can be manipulated).

I have attached a file that contains data that was resolved in the last post, and now includes a new tab called "holidays". In the "holidays" tab, each cell that has a "1" in it represents a day off. So, these need to be deducted from the "Nbr of Days worked" in the "report" tab.

Could you let me know if any of this is possible and how I should do this.

Thanks a lot!