Yeah the paste to row 16 is just proof of concept. The final output will be to another sheet.
The CDate does the job. I was having trouble with some results with the dates in Col C being in date/time format but no matter if I changed .NumberFormat or .Format I could not get rid of the time element.
Your solution certainly helps me get over the immediate hurdle, thanks for your time and effort.