I am reading excel sheets based on the naming convention of dates. They are all supposed to be in this format “MM-dd-yyyy” but sometimes they are submitted without leading zeros for single digit months/days ie: (“M-dd-yyyy” or “MM-d-yyyy” or “M-d-yyyy”)
How would I best handle these input errors so that the program also reads these correctly and does not skip over it?
Example: reading 3 sheets named the following and i want to make sure all are read
Sheet 1: 01-09-2020
Sheet 2: 1-09-2020
Sheet 3: 1-9-2020