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.

 

[CHML]

Not sure how to figure that out.
For now, I need to leave for the night, but I am really thankful for your help here and anyone else's help.

 

[MARK858]

How to change date format on Windows 11 - Pureinfotech

To change the date format on Windows 11, open Settings > Time & language > Language & region > Regional format, click "Change formats."

pureinfotech.com

It will show what you are currently setup as

 

[Alex Blakenburg]

Not sure how to figure that out.
For now, I need to leave for the night, but I am really thankful for your help here and anyone else's help.

It might be quicker to just create a new workbook (ctrl+N). In any Cell enter ctrl+; (semi-colon) it will enter the date.
Show us the date it entered. (formula bar and cell)

 

[CHML]

 

[MARK858]

Then your system is in m/d/yyyyy format.
With your original data can you in B14 put the formula

=ISNUMBER(A14)

and drag the formula down.
Does the formula result in TRUE or FALSE for the cells (judging by your original formula it should be true but just want to double check)?

 

[CHML]

 

[MARK858]

Can you select column A, data - text to columns - Finish . Does the FALSE change to TRUE?

 

[CHML]

Yep,

 

[MARK858]

What does

=TEXT(A14," ddd mmmm yyyyy")

give you now?

 

[CHML]

I modified your formula to A13 (since A14 has a dd of higher >12 which will return the expected results in any case) see results attached.
Then I created a similar formula @ A12. and see results bellow