Count Formula if entry falls between two dates

[ewalker]

Hello all, hope someone out there can help me!!

I have a large list of contracts as abbreviated below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Contract Title[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]Contract 1[/TD]
[TD]23/10/18[/TD]
[TD]31/12/18[/TD]
[/TR]
[TR]
[TD]Contract 2[/TD]
[TD]01/11/18[/TD]
[TD]30/11/18[/TD]
[/TR]
[TR]
[TD]Contract 3[/TD]
[TD]15/10/18[/TD]
[TD]14/12/18[/TD]
[/TR]
[TR]
[TD]Contract 4[/TD]
[TD]22/10/18[/TD]
[TD]28/12/18[/TD]
[/TR]
[TR]
[TD]Contract 5[/TD]
[TD]01/11/18[/TD]
[TD]03/01/19[/TD]
[/TR]
[TR]
[TD]Contract 6[/TD]
[TD]15/11/18[/TD]
[TD]14/12/18[/TD]
[/TR]
[TR]
[TD]Contract 7[/TD]
[TD]08/11/18[/TD]
[TD]21/12/18[/TD]
[/TR]
</tbody>[/TABLE]

I am looking for a formula that will count / amalgamate the number of contracts should they be live within the ranges stated below to produce the results stated. Any assistance would be greatly appreciated

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date Range Start[/TD]
[TD]Date Range End[/TD]
[TD]No of Live Contracts (Results)[/TD]
[/TR]
[TR]
[TD]15/10/18[/TD]
[TD]19/10/18[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]22/10/18[/TD]
[TD]26/10/18[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]29/10/18[/TD]
[TD]02/11/18[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]05/11/18[/TD]
[TD]09/11/18[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]12/11/18[/TD]
[TD]16/11/18[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]19/11/18[/TD]
[TD]23/11/18[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]26/11/18[/TD]
[TD]30/11/18[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/18[/TD]
[TD]07/12/18[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]10/12/18[/TD]
[TD]14/12/18[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]17/12/18[/TD]
[TD]21/12/18[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]24/12/18[/TD]
[TD]28/12/18[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]31/12/18[/TD]
[TD]04/01/19[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Try this, copied down.

Excel Workbook
	A	B	C
1	Contract Title	Start Date	End Date
2	Contract 1	23/10/2018	31/12/2018
3	Contract 2	1/11/2018	30/11/2018
4	Contract 3	15/10/2018	14/12/2018
5	Contract 4	22/10/2018	28/12/2018
6	Contract 5	1/11/2018	3/01/2019
7	Contract 6	15/11/2018	14/12/2018
8	Contract 7	8/11/2018	21/12/2018
9
10
11	Date Range Start	Date Range End	No of Live Contracts (Results)
12	15/10/2018	19/10/2018	1
13	22/10/2018	26/10/2018	3
14	29/10/2018	2/11/2018	5
15	5/11/2018	9/11/2018	6
16	12/11/2018	16/11/2018	7
17	19/11/2018	23/11/2018	7
18	26/11/2018	30/11/2018	7
19	3/12/2018	7/12/2018	6
20	10/12/2018	14/12/2018	6
21	17/12/2018	21/12/2018	4
22	24/12/2018	28/12/2018	3
23	31/12/2018	4/01/2019	2
COUNT Contracts

 

[ewalker]

Fantastic, many thanks!!

 

[Peter_SSs]

Fantastic, many thanks!!

You're welcome.