I saw on your duplicate it was SQL 2008
To do this, you use a query
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\testing.xls;', 'SELECT CONVERT(VARCHAR(10), fmdate(), 101) FROM [SheetName$]') select * from SQLServerTable
Replace Sheetname with the sheet name in the existing excel file.
This will then select the Date and put it in mmddyyy you just need to replace the fmdate with the field i your table and the SQLServer Table with the table itself
If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.