The idea here is to compare the dates in the target worksheet (timecard) with the dates in the source worksheet (data). Is there a better way to compare two dates to see if they match?

To be clear what I wanted to have happen was to take the first date in the target worksheet ("A14") and compare it against the first date in the source worksheet after formatted ("K2"). If they match it is supposed to copy the Rounded Time In and Rounded Time Out times to the target worksheet. Once done it would keep checking the source sheet column of dates ("K") for matches to the first target date, and so on and so forth. Let me know if you want me to explain this any further.

I just thought maybe I am comparing the dates incorrectly, which might be why the code is not moving through this section?
Quote Originally Posted by Norie View Post
The code never goes past this point.
            If sourceInDate.Value = targetDate.Value Then    ' if match goto step 2
It steps right to the End If every time, skipping all the code after the above line.