Report against the milestones but filtered by time not linked to the milestone

[POLACOLOCO]

Hi all,

I m trying to create a report that will be able to show me the numbers forecasted against the achieved per month/week/day - I was hoping you could help me please as I was googling it, reading different forums and tried to sort it out myself but couldnt in the end. Now I m completely brain freezed and I m sure it must be easy to do.
I m using Excel 2010. (BTW i work in telecoms - and this is the life cycle of the site/product where one milestone is followed by another)
The data that I am provided is a daily excel dump containing 131 columns and around 7000 rows where Columns represent different milestones (or other criteria/blockers) that I m interested in or have to take into consideration and rows represent specific sites (locations) identified by a number.
The cell input is usually a date (against the milestones) or text against other criteria

I would like to focus on around 15-20 milestones that I want to report against the sites(locations) to give you an example the table would look more or less like this
[TABLE="width: 890"]
<tbody>[TR]
[TD]NewCellID[/TD]
[TD]Status[/TD]
[TD]Instructed to[/TD]
[TD]Instruction Date[/TD]
[TD]MS4 Design Survey Fcast[/TD]
[TD]MS4 Design Survey Act[/TD]
[TD]Design Drawings Submitted[/TD]
[TD]Design Drawings Approved[/TD]
[TD]MS6 4G Access Forecast Date[/TD]
[TD]MS6 4G Access Actual Inc Date[/TD]
[TD]AHOP Issued For Approval Date[/TD]
[TD]AHOP Approved Date[/TD]
[/TR]
[TR]
[TD]AAA001[/TD]
[TD]Live[/TD]
[TD]Copmany 1[/TD]
[TD="align: right"]05/04/2014[/TD]
[TD="align: right"]02/05/2014[/TD]
[TD="align: right"]24/04/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15/08/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AAA213[/TD]
[TD]On-Hold[/TD]
[TD]Company 2[/TD]
[TD="align: right"]17/03/2014[/TD]
[TD="align: right"]07/04/2014[/TD]
[TD="align: right"]07/04/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30/05/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BAB412[/TD]
[TD]Aborted[/TD]
[TD]Company 3[/TD]
[TD="align: right"]17/02/2014[/TD]
[TD="align: right"]10/04/2014[/TD]
[TD="align: right"]10/04/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/05/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DSA005[/TD]
[TD]Live[/TD]
[TD]Company 4[/TD]
[TD="align: right"]17/03/2014[/TD]
[TD="align: right"]13/06/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/07/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SFE852[/TD]
[TD]Live[/TD]
[TD]Company 5[/TD]
[TD="align: right"]20/06/2013[/TD]
[TD="align: right"]27/06/2013[/TD]
[TD="align: right"]27/06/2013[/TD]
[TD="align: right"]09/04/2014[/TD]
[TD][/TD]
[TD="align: right"]21/06/2014[/TD]
[TD="align: right"]27/09/2013[/TD]
[TD="align: right"]08/11/2013[/TD]
[TD="align: right"]08/11/2013[/TD]
[/TR]
[TR]
[TD]FFS046[/TD]
[TD]Inscope not in Phase[/TD]
[TD]Other[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POD099[/TD]
[TD]Live[/TD]
[TD]Pending[/TD]
[TD="align: right"]28/03/2014[/TD]
[TD="align: right"]09/05/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15/08/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I ve created a report reflecting what is forecasted and what was completed as general numbers using sumproduct funcion with multiple criteria eg.
=SUMPRODUCT(('Source Data'!Y:Y="Live")*('Source Data'!AA:AA<>"")*('Source Data'!Z:Z="Company 1")+('Source Data'!Y:Y="On-Hold")*('Source Data'!AA:AA<>"")*('Source Data'!Z:Z="Company 1"))

where SourceDataY:Y is the "status" column from above and SourceDataA:A is one of the milestones.
THat gave me summary of what was completed/forecasted per company per mileston so far.
It looks more or less like this:
[TABLE="width: 332"]
<tbody>[TR]
[TD][/TD]
[TD]Company 1[/TD]
[TD]Company 2[/TD]
[/TR]
[TR]
[TD]MS4 Design Survey Fcast[/TD]
[TD="align: right"]1547[/TD]
[TD="align: right"]1666[/TD]
[/TR]
[TR]
[TD]MS4 Design Survey Act[/TD]
[TD="align: right"]821[/TD]
[TD="align: right"]1266[/TD]
[/TR]
[TR]
[TD]Design Drawings Submitted[/TD]
[TD="align: right"]484[/TD]
[TD="align: right"]814[/TD]
[/TR]
[TR]
[TD]Design Drawings Approved[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]726[/TD]
[/TR]
[TR]
[TD]MS6 4G Access Forecast Date[/TD]
[TD="align: right"]484[/TD]
[TD="align: right"]814[/TD]
[/TR]
[TR]
[TD]MS6 4G Access Actual Inc Date[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]726[/TD]
[/TR]
[TR]
[TD]AHOP Issued For Approval Date[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]465[/TD]
[/TR]
[TR]
[TD]AHOP Approved Date[/TD]
[TD="align: right"]338[/TD]
[TD="align: right"]440[/TD]
[/TR]
</tbody>[/TABLE]


Its not ideal as if the extra company is added then I will have to expend of the report but I couldnt come up with the good enough pivot for that but I can live with that for now. Of course if you have any suggestions for that please share

THE BIT I M AFTER is to create a report showing the general numbers as the one I ve mentioned above but split into the time frame with the Start Date and End Date that i could end.
Example would be filter the above against what the Company 1 and Company 2 have as forecast for May with a weekly split and what they actually achieved over the same period.
The layout can be exactly the same as the report above but doesnt have to be.

The mulitple milestones follow each other hence MS5 happens after MS4 + X days (where X can vary)
I would also like to be able to double click like in the pivot and get those specific sites/lines shown if needed (that would be a bonus)

When I tried to Pivot it then picking one of the Milestones and grouping it per month or week was limiting other milestones - if you know what i mean - I m interested in different/seperate sites(rows) that have any of their milestones planned or completed within the specific time frame - thats the area when i hit the brick wall
Hence one site will have only design forecast and completion (M4) in May but another site (row) will have design, access AHOP etc all done and forecasted in May.
I would like to see it split into weeks as well as into months.
I am thinking of doing a monthly report showing weekly split and another report showing 3 month forecast showing the completions per month.

I hope I didnt overkill the explanation but if you have any questions please ask.
I have tried pivot/slicers/grouping etc and its not really working for me.

Please help
thank you,