By almost I mean that dates did not include the time
if your example is according to the screenshot, then clean the cell A1, and try to run macro again.