Import Excel spreadsheet into SQL

I have an excel spreadsheet with two date columns among other columns and their cell type is set to date.  I am trying to import the data into an existing SQL DB table. The import wizard is hanging up on the date format type - the source file (excel) is showing date time while the destination is showing date.

I am wondering how to do I get the excel file to just be a date field and not a date/time field.  I have tried changing the date cell type to different date types as well as custom formating but it continues to display date time instead of just date

thanks in advanced...