Lastdate7 is set to be 7 days less than lastdate
Your Do loop does not action because lastdate7 is already less than lastdate