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):
<tbody>
</tbody>
Any help would be greatly appreciated. Thank you so much!
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):
Location | Start Date | End Date | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |
1/10/2015 | 8/10/2015 | etc | etc | etc | etc | etc | etc | etc | etc | etc | etc | |||
London | 1/10/2015 | 31/10/2015 | 7 | 7 | 7 | 7 | ||||||||
Berlin | 14/10/2015 | 14/11/2015 | 7 | 7 | 7 | 7 | ||||||||
Istanbul | 1/11/2015 | 22/11/2015 | 7 | 7 | 4 |
<tbody>
</tbody>
Any help would be greatly appreciated. Thank you so much!