Count multiple installation start and end date ranges in each week, of each year

danquale 

I took a look at this yesterday when you first posted and decided to leave it for somebody else to sort through the morass of information you provided. I see that at least 38 other people appear to have done the same.

May I suggest to you that you simplify/clarify what you're asking. The question itself appears to be fairly simple, but you're asking an awful lot of any of us who might want to help--two links to google spreadsheets appear in your posting itself, plus two Excel workbooks, each of which has notations in it meant, I'm sure, as directions, some of them from you and some to you....

It's too much.

You need to remember, the people here who want to help are not being paid for the time we take. It's because we enjoy helping people understand what Excel does; not because we are mind-readers or cryptanalysts.

So if you could create a simple workbook that just represents the core installation database, dates of start and end, and whatever else is necessary to focus in on the precise problem for which you're seeking help, I'm sure that one of those 38+ people would be delighted to offer some suggestions.