Hi,

Rather than use loops which are inherently slow and if there is standard functionality available you should use that.
In this case I'd be inclined to use a standard IF function to populate the columns 1 or 2 with your dates.

You could enlist the help of a macro to do this and add the function to the relevant block of cells in a single instruction. The big advantage is that you don't need a loop of any sort, either a DO loop or a FOR loop