Excel Return all data that is on a specific weekday and on a certain month

[SimonVOwen]

Hello All,

I have data for the whole year for numerous items
I am trying to search the data to find a specific day and return the whole row of data.
I am want the search to continue and find all the other data that matches the data criteria.
I am unsure how to make a formula that continually searches after finding one correct row.
Ideally it would need to be able to find 2 specific criteria.

So I would want to return data that appeared on day 2.
Also the month would need to be between the values in start month and end month.
So a >= Start Month / <= End Month

I can work out the coding for the criteria searching most likely, it is just knowing what code to use to Scan Data and keep returning rows of data that I am unsure off.
Any help would be much appreciated.

A	B	C	D	E	F	G	H	I
Time Pattern Regime ID		Day of the Week ID	Start Day	Start Month	End Day	End Month	Start Time	End Time
1		1	1	1	31	12	0:00	24:00:00
1		2	1	1	31	12	0:00	24:00:00

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col></colgroup>

​		​					​
​			​	​				​

<tbody>
</tbody><colgroup><col span="7"><col><col></colgroup>