Cell format changes when paste to another worksheet

I have tried many ways of changing formatting to retain the dates in cells when I copy a a column of cells from one sheet to another

I only have problem with one column (column D) when i copy and paste to another worksheet. It does not retain the original dates. It changes the dates to a date that is unusual.

Any solutions appreciated