Zapier seems to format dates wrong when writing to google sheets.
It converts this
into this
If I switch the 2 top with 2 bottom I get the same result. I have even tried having the columns around the table, I still keep getting 2 of the dates parsed wrong.
This is extremely frustrating, and makes me unable to enter more than 2 dates properly.
EDIT: Adding a fake row with correct format seems to have fixed it...