Date formatting issue

[CHML]

Hi, After downloading a report, I noticed that somehow, Excel caught up services for (in this image scenario) December 10, 2023, as October 12, 2023 (in numeric format).
How can I tell Excel to treat the 2 first digits on the left as the Month, and the mid as days? If I simply do by formatting to "mm/dd/yyyy" It still thinks its October and shows as 10/12/2023.

If you help with a formula perspective, consider there are some dates that have only 1 digit as the day.

Thanking you in advance.

 

[MARK858]

I still want to know what the formula returns for A14 as requested

 

[CHML]

 

[MARK858]

Can you leave the formulas as they are and repeat the steps in post 2 (as long as you did select the entire column in post 17) and post the results

 

[CHML]

Did that. Any specific cell that you want me to post?

 

[MARK858]

What does

=ISNUMBER(A13)

return?

 

[CHML]

 

[CHML]

Just sharing, my main goal was to create in column B a simple formula to show the week number of column A. The way it displays the date, that I don't care too much. It's the week number that got messed up.

 

[MARK858]

Just sharing, my main goal was to create in column B a simple formula to show the week number of column A

Week number won't work unless the dates are right, at the moment they don't look like they are, they all should return December. Text to Columns isn't a format

 

[CHML]

Well, that's precisely why I brought my question to this platform; to fix dates in column A. But I was thinking of a formula perspective but I still didn't figure out the appropriate one.

 

[MARK858]

Do you still have access to the original report to download?