I have a spreadsheet with a project on, which has different activities with different deadlines, running parallel.

[u635858]

How do I make it so I can see which activities should have been completed in a certain time frame (e.g 1 month).
Which ones have been completed, and then which ones have over ran, so have not met their deadline.
And can these also be counted up at the end? So a total of completed and not completed??

Thank you in advance!!!

 

[oldbrewer]

copy first 5 rows onto here please

 

[u635858]

[TABLE="width: 1996"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Id[/TD]
[TD]Gate 0 Baseline[/TD]
[TD]Gate 0 Forecast[/TD]
[TD]Gate 0 Actual[/TD]
[TD]Gate 1 Baseline[/TD]
[TD]Gate 1 Forecast[/TD]
[TD]Gate 1 Actual[/TD]
[TD]Gate 2 Baseline[/TD]
[TD]Gate 2 Forecast[/TD]
[TD]Gate 2 Actual[/TD]
[TD]Cutover Complete Baseline[/TD]
[TD]Cutover Complete Forecast[/TD]
[TD]Cutover Complete Actual[/TD]
[TD]Gate 3 Baseline[/TD]
[TD]Gate 3 Forecast[/TD]
[TD]Gate 3 Actual[/TD]
[/TR]
[TR]
[TD]Activity 1[/TD]
[TD="align: right"]12-Jun-2015[/TD]
[TD="align: right"]19-May-2015[/TD]
[TD="align: right"]19-May-2015[/TD]
[TD="align: right"]18-Sep-2015[/TD]
[TD="align: right"]18-Sep-2015[/TD]
[TD="align: right"]24-Sep-2015[/TD]
[TD="align: right"]18-Dec-2015[/TD]
[TD="align: right"]17-Feb-2016[/TD]
[TD="align: right"]17-Feb-2016[/TD]
[TD="align: right"]15-May-2020[/TD]
[TD="align: right"]15-May-2020[/TD]
[TD] [/TD]
[TD="align: right"]30-May-2020[/TD]
[TD="align: right"]30-May-2020[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Activity 2[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]12-Jan-2019[/TD]
[TD="align: right"]12-Jan-2019[/TD]
[TD] [/TD]
[TD="align: right"]1-Nov-2019[/TD]
[TD="align: right"]1-Aug-2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Avtivity 3[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD="align: right"]13-Mar-2018[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Activity 4[/TD]
[TD="align: right"]15-Dec-2018[/TD]
[TD="align: right"]15-Dec-2018[/TD]
[TD="align: right"]15-Dec-2018[/TD]
[TD="align: right"]1-May-2018[/TD]
[TD="align: right"]1-May-2019[/TD]
[TD="align: right"]2-Aug-2018[/TD]
[TD="align: right"]30-May-2018[/TD]
[TD="align: right"]30-May-2019[/TD]
[TD="align: right"]2-Aug-2018[/TD]
[TD="align: right"]1-Jan-2021[/TD]
[TD="align: right"]1-Jan-2022[/TD]
[TD] [/TD]
[TD="align: right"]1-Jun-2021[/TD]
[TD="align: right"]1-Jun-2022[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Activity 5[/TD]
[TD="align: right"]22-Sep-2017[/TD]
[TD="align: right"]22-Sep-2017[/TD]
[TD] [/TD]
[TD="align: right"]22-Sep-2017[/TD]
[TD="align: right"]22-Sep-2017[/TD]
[TD] [/TD]
[TD="align: right"]31-Oct-2017[/TD]
[TD="align: right"]31-Oct-2017[/TD]
[TD] [/TD]
[TD="align: right"]20-Dec-2018[/TD]
[TD="align: right"]20-Dec-2018[/TD]
[TD] [/TD]
[TD="align: right"]1-Jan-2019[/TD]
[TD="align: right"]1-Jan-2019[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]