Calculate active days broken down by weeks in a quarter

[hierosir]

Hi guys,

Thanks in advance. I have a requirement for a work project. In essence, it's scheduling/resourcing of locations. Want to be able to see at a glance how many "days" a location is active in a given week - the year is broken into quarters. Here's example (numbers might not be exact, I'm just typing it out in principle):

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Week 1[/TD]
[TD]Week 2[/TD]
[TD]Week 3[/TD]
[TD]Week 4[/TD]
[TD]Week 5[/TD]
[TD]Week 6[/TD]
[TD]Week 7[/TD]
[TD]Week 8[/TD]
[TD]Week 9[/TD]
[TD]Week 10[/TD]
[TD]Week 11[/TD]
[TD]Week 12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1/10/2015[/TD]
[TD]8/10/2015[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD]1/10/2015[/TD]
[TD]31/10/2015[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Berlin[/TD]
[TD]14/10/2015[/TD]
[TD]14/11/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Istanbul[/TD]
[TD]1/11/2015[/TD]
[TD]22/11/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









Any help would be greatly appreciated. Thank you so much!