In the bit of code:
If Cells(i, "F").Value = Date
The "Date" function returns the current date. So if you run it tomorrow, it will check against tomorrow's date, etc.