Find the intersection of 4 periods

[Flyingjoblo]

Hi everyone,
I am looking for a way to find the number of days at the intersection of 4 different periods using max/min formulas as stated in an old thread of 2009.
Anyone interested to help?
Exemple:
How many days included in all of the following periods:
1/3/2023-5/4/2025
6/6/2022-8/10/2030
9/1/2025-15/1/2025
10/2/2028-20/2/2028

 

[kevin9999]

Book1
	A	B	C
1	1/03/2023	5/04/2025	period 1
2	6/06/2022	8/10/2030	period 2
3	9/01/2025	15/01/2025	period 3
4	11/01/2025	17/02/2025	period 4
5
6	1/04/2024	2/10/2027	reference period
7
8	5	How about this instead?
9
Sheet1

Cell Formulas
Range	Formula
A8	A8	=MAX(MINIFS(B1:B4,B1:B4,"<="&B6)-MAXIFS(A1:A4,A1:A4,">="&A6)+1,0)