Yeah - I don’t get to determine what date format 3rd party reports are generated in before I import into excel.

But excel has formatting options specifically designed to address this that it just ignores half the time.