Problems with Date Formats

[RobRayborn]

I am having problems with a file of Excel worksheets.  
I have almost 11 months of data with one Excel file per workday.

Within the worksheet I have a column of Dates.  All of these are in this format: _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

While I was attemting to pull all these excel files in I found out that all the files from March had incorrect dates for the last four days in the date column the Year increased by one each time.  When I had the creator of these files go in and fix this problem now all of March shows up as Numeric (3/1/2023 = 44986).  I have not been able to figure out how to get everythingin that column to line up as a Date.  I have changed the column from General to Number, then to date. I've tried from General to Text to Date, no luck. I've tried about every combo I can think of.  
Before I go back to the Creators of these files and tell them they have to make alllll the rest of the Date columns like they did with March, I was hoping that someone out there could provide me with some help.

[RobRayborn]

I was afraid of that.

[aj1973 · Accepted solution]

Hi @RobRayborn 

Best way to fix it is directly into the source. Keep harrasing the creator to correctly format the whole field in excel better than wasting time in Power Query and DAX in Power BI.