Inserts the date into the column ok. But I can't figure out how to change the cell/ column from General (which shows the date as a number) to ShortDate
I need the final spreadsheet to be opened in Excel with the dates showing as dates.
Normally the easiest way to answer this kind of questions is to use APIMate. Just create an empty file in Excel, write a date in A1, save the file and open it in APIMate (search for apimate in the start menu)