Read dates in (several) local languages

[DeepButi]

I can easily display a date in any local language using TEXT :

but I need to do exactly the opposite. I get a file with dates in diferent local languages and want to convert them to dates:

In fact, just the month name is the problem. Any ideas?

Obviously, I cannot change the local language of the file because there is a mix of languages, so please don't tell me to do so!

Thks

 

[JvdV]

With known mix of LCID-language codes, maybe you could list them if it's just a handfull:

Book1
	A	B
1	05 gener 2023	44931
2	05 January 2023	44931
3	05 jasyteĩ 2023	44931
Sheet4

Cell Formulas
Range	Formula
B1:B3	B1	=--MAP(A1:A3,LAMBDA(s,LEFT(s,2)&"/"&MAX(IF(COUNTIF(A1,TEXT("1-"&SEQUENCE(12),"[$-"&{403,407,474}&"]\* mmmm \*")),SEQUENCE(12)))&"/"&RIGHT(s,4)))
Dynamic array formulas.

 

[DeepButi]

Wow! Nice try. I assume COUNTIF(A1 must be COUNTIF(s
It doesn't exactly work (try diferent days on column A) because the sequence inside COUNTIF generates months in a language order: Gener (403) Februar (407) jasyapy (474) ...
I will work on it.
Thanks

 

[DeepButi]

Solved! Thks

=--MAP(A9:A11;LAMBDA(s;LEFT(s;2) & "/" & MAX(IF(COUNTIF(s;TEXT("1-" & SEQUENCE(12);"[" & OFFSET(s;0;1) & "]\* mmmm \*"));SEQUENCE(12))) & "/"&RIGHT(s;4)))

 

[JvdV]

Ah yes I meant to write the 's' variable there. Cool to see you got it sorted!!