We can change the date format in your Excel file, forgetme.
Before doing this process, we have to make sure that we've selected the appropriate date format that matches our QuickBooks transactions. In that way, we can avoid getting any errors.
Here are the steps:
- Highlight the Date column in your MS Excel file.
- Click the Number icon at the top.
- Select Custom and type the date format to wish to achieve.
- Click OK.
Please see attached screenshots:


After performing the steps, we'll be able to successfully import the transactions with the format date we wanted.
Please leave a comment below if there's anything else I do to help with changing your CSV file date format. Thanks!