New filter function with multiple criteria

I am using this formula which works fine, but need to add one more condition
(date condition)

=FILTER(INDEX(Table2,SEQUENCE(ROWS(Table2)),{14,2,3,12,13}),(Table2[Column2]>=$C$13)*(Table2[Column2]<=$E$13))


Please see the attached file.

Thank you.

Dear Bo_Ry,
Thank you but the output is not working when the dates / price data is changed. Also, this is sample
data, the actual table has more columns...from the formula I can't figure out the column numbers

My apologies if I was not clear from the beginning.

The sample data is the actual format I will be using for my real data...just the numbers are different.
My formula that used column numbers are very clear, it would just be more or less, instead of putting all columns
I chose to put a few, the real issue is the date part in the formula.
My sample formula uses 2 criteria and both work well, just need to add 1 more criteria (the date part).

I can't thank enough for all the help I have received in this forum.

Thanks again.

The new file attached, please have a look, hope my request is clear.

Thanks again.
Cheers.

Thank you so much Bo_Ry, your formula works as desired.

I have a question though, may I know which part of the formula I need to change if I add or remove columns.
for example.. I add few columns at the beginning of the table and it works fine, but adding columns at the end of
the table gives a different result.

Not that I intend to add columns now, but would appreciate if I know which part of the formula to change so that I
can do so as and when required in the future.

Please see the attached file.

Thanks a lot.

Kindly note that it's not continual adding of requirements, just trying to learn where the formula can be modified so I can do it
without asking for further help.

Thank you once again. Highly appreciate all the help.

Thank you Bo_Ry. You are a gem.

Originally Posted by Bo_Ry

Last Try, change in the red

=FILTER(INDEX(Table2,SEQUENCE(ROWS(Table2)),MID(CONCAT(COLUMNS(Table2)-1,TEXT(MATCH(G15,A1:R1)-{1,0},"00"),COLUMNS(Table2)-{3,2}),SEQUENCE(,5,,2),2)),(INDEX(Table2,,MATCH(G15,A1:R1)-1)>=$G$16)*(INDEX(Table2,,MATCH(G15,A1:R1)-1)<=$I$16))