Excel data changing format upon upload

Looking at your code,  I see that your Excel Import includes Kind = Sheet.  If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table].  If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T.  If the info is in this current workbook, then Get data from Table/Range will do this automatically.  Honestly, though, I never considered whether or not coulmn names respect date formats or data types.

Wait though, can[t you make these columns type text, and then promote headers?  Once you do that, and then promote headers, you cna always go back and change the type.

--Nate