Dates are stored as whole numbers (days elapsed since the reference
date), whereas times are stored as fractions of a 24 hour day. So, you
can get the date part by

=INT(A1)

if A1 holds your date/time combination. Format as required, then the
formula can be copied down.

Hope this helps.

Pete