Date format issue

You are welcome

you can use Data Validation to check if right date is bigger than left date and block improper manual entry (with copy/paste it doesn't work!)

so if the problem is solved, hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)