New answers tagged automation
Have a look at wp-cli and wp-api they could help you automate your process without you needing to know too much about wordpress.
I would suggest opening CSV in Excel and use formatting to convert all dates to the same format and save CSV before using this for importing. This should avoid any development efforts.
Top 50 recent answers are included