Records in between two specific dates easily can be filtered using drop-down lists .
Drop-down lists were filled with unique values as ascending order using Ado connection. Thus, it is easier to choose between the dates on the worksheet.
The filtered data can be copied to other sheet if it wished.

Watch the video to see how it's done and download example file : https://youtu.be/baHyGS7i9n0