need formula to count number of open trades at once

[NeedExcelHelp2021]

Explanation: trade #2 got open before trade #1 ended so 2 trades open at once,
trade #2 ended before trade #3 Entry Date so 2 trades open at once at trade #3 (Trade#1 Open,Trade#2 Closed,Trade#3 Open)= At Trade #3 (2 Trades Open At Once)


Thank you for any help.

Book2
	A	B	C	D	E	F	G	H
1	Trade #	Entry Date	Exit Date	# of trades open at once
2	1	1/14/2009	10/21/2009	1
3	2	1/19/2009	1/21/2009	2
4	3	1/27/2009	1/28/2009	2
5	4	2/8/2009	3/23/2009	2
6	5	3/4/2009	10/19/2009	3
7	6	3/4/2009	5/7/2009	4
8	7	3/11/2009	3/16/2009	5
9	8	3/12/2009	12/23/2009	6
10	9	4/2/2009	4/6/2009	5
11	10	4/21/2009	6/1/2009	5
12
13
14
15
16
Sheet3

 

[maabadi]

Welcome to MrExcel Message Board.
Try this:

Book1
	A	B	C	D	E	F	G
1	Trade #	Entry Date	Exit Date	# of trades open at once
2	1	1/14/2009	10/21/2009	1		1
3	2	1/19/2009	1/21/2009	2		2
4	3	1/27/2009	1/28/2009	2		2
5	4	2/8/2009	3/23/2009	2		2
6	5	3/4/2009	10/19/2009	3		3
7	6	3/4/2009	5/7/2009	4		4
8	7	3/11/2009	3/16/2009	5		5
9	8	3/12/2009	12/23/2009	6		6
10	9	4/2/2009	4/6/2009	5		5
11	10	4/21/2009	6/1/2009	5		5
12
Sheet1

Cell Formulas
Range	Formula
F2:F11	F2	=COUNTIFS($C$1:C1, ">" &B2) + 1

 

[NeedExcelHelp2021]

Welcome to MrExcel Message Board.
Try this:

Book1
	A	B	C	D	E	F	G
1	Trade #	Entry Date	Exit Date	# of trades open at once
2	1	1/14/2009	10/21/2009	1		1
3	2	1/19/2009	1/21/2009	2		2
4	3	1/27/2009	1/28/2009	2		2
5	4	2/8/2009	3/23/2009	2		2
6	5	3/4/2009	10/19/2009	3		3
7	6	3/4/2009	5/7/2009	4		4
8	7	3/11/2009	3/16/2009	5		5
9	8	3/12/2009	12/23/2009	6		6
10	9	4/2/2009	4/6/2009	5		5
11	10	4/21/2009	6/1/2009	5		5
12
Sheet1

Cell Formulas
Range	Formula
F2:F11	F2	=COUNTIFS($C$1:C1, ">" &B2) + 1

Works perfectly! Thank You Every Much.

 

[maabadi]

You're Welcome & Thanks for follow-up.