You misunderstand. I'm not saying that code will work any differently. However, I recorded a simple macro which is shown first and then I "cleaned it up" to avoid ".Select ... Selection." Both versions, in my empty workbook, work as expected. That is, they copy a cell value, which happens to be a date, and pastes the value into another cell, which is formatted as a date.

So, if that isn't happening for you, I suspect that the problem lies elsewhere. But, without seeing what you are working with, I cannot investigate or explain what is going wrong.