You are really confusing me.

I wrote that code as your requirement, and it was all good.
you don't need to do that , because your code does that when select all and write dates


What I meant was if the dates should be considered to create extra rows for "new" even the date are not in the range between From : To date.

As I already asked, I need to see your desired result workbook in various situations, clearly showing the logic like "new" and "delete" etc. otherwise just wasting time.