in year contained in Year Range

[RayBan]

I thought coding this would be dead easy, but can't get it right!

There's a range of years, say 1950 to 1970

Then another range 1945 to 1955.

I want to know if any year in the second range, exists in the first range. Have tried all sorts of < and > and juggling the
four year values but nothing works out correctly. Maybe there's a cleverer approach?

 

[T. Valko]

Not real sure what you're looking for.

This formula will count how many years are within both time periods.

Data Range

	A​	B​	C​	D​	E​
1​	Period 1​	1950​	1970​	------​	In Both​
2​	Period 2​	1945​	1955​		6​

=MAX(0,MIN(C1,C2)-MAX(B1,B2)+1)

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	F​	G​
1​
2​	1950​	1970​		1945​	1955​	TRUE​	TRUE​
3​

=AND(E2>=A2,D2<=B2)

Using brute force:

=ISNUMBER(LOOKUP(9.99999999999999E+307,MATCH(ROW(INDIRECT(D2&":"&E2)),ROW(INDIRECT(A2&":"&B2)),0)))