Expired data copy to another sheet. But expired data repeat when i run it.

Hey, weird. I tried to with date like 01/01/2020. It wont copy and paste.
Hence i key in 01/01/2018 to 31/12/2018. Then weird, it will copy till 03/10/2018. I aso duno y it will stop at that date.
If onli i can make a video to show u.... see the excel for "proof"