Count Days between dates

[johnce123]

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

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

 

[Tetra201]

Assuming you have your data table in range C1:I25, see if the following formula works for you:

=SUMPRODUCT((C2:C25=A3)*({-1,1}*ABS(A2*{1,-1}-D2:D25)-ABS(H2:H25-A1*{1,-1})+1))/2