Counting Overlapping Dates

[Flint66]

Been working for a hour and can not come up with a working formula. I want to have a total of time each date range over laps for each day on the left (I put in a couple numbers just to demonstrate).

 

[KRice]

I want to have a total of time each date range over laps for each day on the left

Do you mean the number of times each date on the left is included in a date range on the right? So for May 10 the expected answer would be 3?

 

[KRice]

Like this?

MrExcel_20220505B.xlsx
	A	B	C	D	E
1				Date Ranges
2	Date	Count of Ranges that Include Date		Start	End
3	5/1/2022	1		5/1/2022	5/6/2022
4	5/2/2022	2		5/5/2022	5/16/2022
5	5/3/2022	2		5/8/2022	5/18/2022
6	5/4/2022	2		5/2/2022	5/4/2022
7	5/5/2022	2		5/11/2022	5/19/2022
8	5/6/2022	2
9	5/7/2022	1
10	5/8/2022	2
11	5/9/2022	2
12	5/10/2022	2
13	5/11/2022	3
14	5/12/2022	3
15	5/13/2022	3
16	5/14/2022	3
17	5/15/2022	3
18	5/16/2022	3
19	5/17/2022	2
20	5/18/2022	2
21	5/19/2022	1
22	5/20/2022	0
Sheet5

Cell Formulas
Range	Formula
B3:B22	B3	=COUNTIFS($D$3:$D$7,"<="&A3,$E$3:$E$7,">="&A3)

 

[Flint66]

Exactly thank you so much.

 

[KRice]

Great!...happy to help, and welcome to the MrExcel board.