Problem with date filter vba code

In this workbook I want to filter the dates by the criteria I have put in cells i2 and j2.
In the range from a1 until E315 I have my range,in the cells i2 and j2 I have my criteria range(start and end date) and in cell i6 is the destination that I want my filtered range to start.the cells i2 and j2 are connected with cells M2 and N2 because I have put and the bigger and smaller sign
i don’t know why my code is not working..i have put and the criteria range correct and the range I want to filter ,as the destination range also.can you help me please?

Criteria settings needs to be changed like attached.

Header(s) in criteria must be identical to data range.

Originally Posted by jindon

Criteria settings needs to be changed like attached.

Header(s) in criteria must be identical to data range.

hallo from Greece and thank you very much for your response.is the a way in the cell M2 and N3 the format to be more readable?like this format 24/03/2023.even with helping columns

Then use formula,

Criteria in I2:J2.

Please Login or Register  to view this content.

Originally Posted by rorya

You just need a few changes to your original workbook - see attached. Note: you should not have the start and end criteria on two separate rows as that is an OR criteria setup, not an AND.

Τhank you very much my friend.this is working perfectly.can you tell me please what modifications have you made?

Originally Posted by jindon

Then use formula,

Criteria in I2:J2.

Please Login or Register  to view this content.

this is working also perfectly.when you say [p2] you are referring to the cell p2?if yes why specific this cell ?
thank you in advance

Now criteria range is P1:P2.
P1 needs to be blank and P2 should have formula resulting True/False for the 1st row of data.

Originally Posted by rorya

I amended your criteria headers to match the original data column header.

Thank you very much my friend for all the effort you made for me and the explanation

Originally Posted by rorya

I amended your criteria headers to match the original data column header.

thank you very much for the explanation and you r effort.this is first time i see that.i believe is more advanced for my knowledge.