I downloaded CSV data from my Etsy shop to calculate taxes. I'd like to have the date "copied" properly.
The CSV date I get from Etsy is formatted as "02/09/16"
This is "2 September 2016" in Dutch but "September 2 2016" in English.
I cannot seem to find a way to change this to the correct date. When changing language / time and locale settings, Google Sheets always makes sure it's exactly wrong. Setting everything to US or AUS returns the date as a Dutch date, setting everything to Dutch returns an English date!
I was thinking, I could extract the 2 numbers before the first dash "02", which is the month, and use
=vlookup() to look up the month from a data sheet and paste this into a correct date. It seems to be a silly workaround but I can't seem to change the date properly.
Col.A Col.B Row. 1) 01 January Row. 2) 02 February
Lookup 01 and return B1. And so on…
Any ideas? I'm not exactly an Excel / spreadsheets guru.