Overlapping dates

[CaptArt]

I have two columns of dates ranging through out the year, written mm dd yyyy HH:MM. Them I have a cell with a single start date and a cell with a single end date written the same format as above. I need a list of dates that over lap and the amount of hours. Help!?

 

[Sufiyan97]

Hi
Welcome to MrExcel!

Do you want something like this?

Book3
	A	B	C	D	E	F	G
1	Dates		Start Date	End Date		List Of Dates
2	1/1/2022		1/1/2022	1/10/2022		1/1/2022
3	1/2/2022					1/2/2022
4	1/3/2022					1/3/2022
5	1/4/2022					1/4/2022
6	1/5/2022					1/5/2022
7	1/6/2022					1/6/2022
8	1/7/2022					1/7/2022
9	1/8/2022					1/8/2022
10	1/9/2022					1/9/2022
11	1/10/2022					1/10/2022
12	1/11/2022
13	1/12/2022
14	1/13/2022
15	1/14/2022
16	1/15/2022
17	1/16/2022
18	1/17/2022
19	1/18/2022
20	1/19/2022
21	1/20/2022
22	1/21/2022
23	1/22/2022
24	1/23/2022
25	1/24/2022
26	1/25/2022
27	1/26/2022
28	1/27/2022
29	1/28/2022
30	1/29/2022
31	1/30/2022
32	1/31/2022
Sheet1

Cell Formulas
Range	Formula
A3:A32	A3	=A2+1
F2:F32	F2	=IFERROR(INDEX($A$2:$A$366,AGGREGATE(15,6,(ROW($A$2:$A$366)-ROW($A$2)+1)/($A$2:$A$366>=$C$2)/($A$2:$A$366<=$D$2),ROWS($F$1:F1))),"")