convert date column to general value

Try

=datevalue(D2) 
=datevalue(g2)

and copy down


Or better way, copy an emty cell, then select entire column with dates then right click > paste special > add > ok
Then apply dd mm yy format to these values