Check the if any date from a row / table matches a period of time

[vladimiratanasiu]

Hello!

I have a list of a project with its associated subprojects. Each activity is allocated two cells, one for the time and the second for a short description of results. I need a formula to check horizontally each row with dates, or the whole table, to see if any date ( e.g. 02/06/2022, 16/07/2022 etc.) fits the checked period (e.g. 01/06/2022-31/05/2023). If it matches that period, I wish the associated subproject to be deleted from this table and moved in another file (e.g. Sheet 2).

Thank you!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date 1	Date 2	Activities
2	01/06/2022	31/05/2023	1		2		3		4		5
3	Subproject 1		02/06/2022	…....	17/09/2022	…....	15/12/2023	…....	x	…....	x	…....
4	Subproject 2		02/03/2022	…....	16/07/2022	…....	01/10/2022	…....	x	…....	x	…....
Sheet1