Hi,
I have a table like the below and want to be able to see what percentage of each month had been closed within the allowed time. For example row two has an end date of the 26/08/2020 and the issue was closed on the 21/07/2020 so therefore this was completed in date and would be 100% however i need to work out the percentage of all from may/june/july, etc. So i would need to know that for example May was maybe 80% completed on time, then June was 96% or something along those lines.
I'll put the % into a separate table on the same sheet. Column M.
I have a table like the below and want to be able to see what percentage of each month had been closed within the allowed time. For example row two has an end date of the 26/08/2020 and the issue was closed on the 21/07/2020 so therefore this was completed in date and would be 100% however i need to work out the percentage of all from may/june/july, etc. So i would need to know that for example May was maybe 80% completed on time, then June was 96% or something along those lines.
I'll put the % into a separate table on the same sheet. Column M.
A | B | C | D | E | |
1 | Date Raised | Target Date | Days to Go | Date Closed | Status |
2 | 28/05/2020 | 26/08/2020 | 21 | Open - In Target | |
3 | 28/05/2020 | 26/08/2020 | Closed | 21/07/2020 | Closed |
4 | 28/05/2020 | 26/08/2020 | 21 | Open - In Target | |
5 | 24/06/2020 | 24/07/2020 | Closed | 24/07/2020 | Closed |
6 | 24/06/2020 | 24/07/2020 | Closed | 24/07/2020 | Closed |
7 | 24/06/2020 | 24/07/2020 | Closed | 24/07/2020 | Closed |
8 | 24/06/2020 | 24/07/2020 | Closed | 24/07/2020 | Closed |
9 | 24/06/2020 | 23/08/2020 | Closed | 24/07/2020 | Closed |
10 | 24/06/2020 | 22/09/2020 | Closed | 24/07/2020 | Closed |
11 | 24/06/2020 | 22/09/2020 | Closed | 24/07/2020 | Closed |
12 | 24/06/2020 | 22/09/2020 | Closed | 24/07/2020 | Closed |