It is not the validation; before applying the package data, all date-fields already have a prior date, so the problem is in bringing over the data from Excel in to the package tables. I think it is something with the time zones.
There're 2 ways to get around this problem:
- Format the dates as 2019-12-31 instead of 12-31-2019
- In 'My Settings' change your Time Zone to UTC
These workarounds are based on my settings for the US, depending on your local settings this may need to be different.