Good Evening,
I would like to be able to Set a specific date range and count total available days between these date ranges given the table below
Example - Search for the following
Cell a1 Start Date 01/03/2021
cell a2 End Date 31/03/2021
cell a3 Code - CFGOLD8
The formula needs to check if the days fall between the start date and end date in the table below, and how many in total.
It then needs to sum these days up for that particular grade. In this example we would have 2 of the same grades, one with 31 days available and the other with 15 days available - so it returns 46
I hope that kind of makes sense and that its possible! TIA
I would like to be able to Set a specific date range and count total available days between these date ranges given the table below
Example - Search for the following
Cell a1 Start Date 01/03/2021
cell a2 End Date 31/03/2021
cell a3 Code - CFGOLD8
The formula needs to check if the days fall between the start date and end date in the table below, and how many in total.
It then needs to sum these days up for that particular grade. In this example we would have 2 of the same grades, one with 31 days available and the other with 15 days available - so it returns 46
I hope that kind of makes sense and that its possible! TIA
Code | End Date | Entity No. | Entity Park Code | Entity Type | Start Date | Type |
CFPLAT8 | 31/12/9999 | U000000001 | Unit | 01/01/2000 | Grade | |
CF | 31/12/9999 | U000000001 | Unit | 01/01/2020 | Park | |
CFJG127 | 31/12/9999 | U000000001 | Unit | 01/01/2020 | Plot | |
NSGOLD6 | 31/12/9999 | U000000002 | Unit | 01/01/2000 | Grade | |
NS | 31/12/9999 | U000000002 | Unit | 01/01/2020 | Park | |
NSHF17 | 31/12/9999 | U000000002 | Unit | 01/01/2020 | Plot | |
CFGOLD8 | 15/03/2021 | U000000003 | Unit | 01/01/2000 | Grade | |
CF | 31/12/9999 | U000000003 | Unit | 01/01/2020 | Park | |
CFJG134 | 31/12/9999 | U000000003 | Unit | 01/01/2020 | Plot | |
CFGOLD8 | 31/12/9999 | U000000004 | Unit | 01/01/2000 | Grade | |
CF | 31/12/9999 | U000000004 | Unit | 01/01/2020 | Park | |
CFJG087 | 31/12/9999 | U000000004 | Unit | 01/01/2020 | Plot | |
MFGOLD8 | 31/12/9999 | U000000005 | Unit | 01/01/2000 | Grade | |
MF | 31/12/9999 | U000000005 | Unit | 01/01/2020 | Park | |
MFW0014 | 31/12/9999 | U000000005 | Unit | 01/01/2020 | Plot | |
GLGOLD8 | 31/12/9999 | U000000006 | Unit | 01/01/2000 | Grade | |
GL | 31/12/9999 | U000000006 | Unit | 01/01/2020 | Park | |
GLGV092 | 31/12/9999 | U000000006 | Unit | 01/01/2020 | Plot | |
GLGOLD8P | 31/12/9999 | U000000007 | Unit | 01/01/2000 | Grade | |
GL | 31/12/9999 | U000000007 | Unit | 01/01/2020 | Park | |
GLGV075 | 31/12/9999 | U000000007 | Unit | 01/01/2020 | Plot | |
CFGOLD8P | 31/12/9999 | U000000008 | Unit | 01/01/2000 | Grade | |
CF | 31/12/9999 | U000000008 | Unit | 01/01/2020 | Park | |
CFJG142 | 31/12/9999 | U000000008 | Unit | 01/01/2020 | Plot |