how to filter all dates between two dates

[p45cal]

If your 'database' is a table then you can use a slicer (unfortunately not a Time Slicer); click on the first date, hold the shift key down and click on the second date.[Sheet4 cell G1]
Lower down on the sheet I've added a pivot table and a Time Slicer where you can do it in one click: click and drag the days you want to filter for. This pivot table works like a plain filter because there is a unique column of data at the left of the pivot, otherwise it would do what pivot tables are good at which is summarising/aggregating/grouping data rows.[Sheet4 cell E45]
Using VBA, on Sheet2 click on one date then another date in column C and it will filter between those two dates. Keep on clicking (in pairs of clicks) to filter again. You will at one point have to clear the filter to see the dates again. You can click the dates in any order (earlier date/later date). The code is in Sheet2's code-module.