Convert Text to Date

[Rami9]

Hi,
I have 2 columns contains Hijri dates entered as (text), I wonder if possible to convert it to date format where the calendar type is (Hijri)
Thanks

 

[pecoflyer]

Maybe =RIGHT(A2;2)+0&"/"&MID(A2;6;2)+0&"/"&LEFT(A2;4)+0 to convert to latin characters
After that, there are tons of solutions on the web
Here is one https://wikimho.com/us/q/superuser/1274419

 

[Rami9]

Hi
Thanks @pecoflyer , but unfortunately it's not the solutions I need.
anyone can help me to sort it out.

 

[Marc L]

Hi, as pecoflyer's formula works on my side once semi colons are replaced with commas …​

​

 

[pecoflyer]

Hi, as pecoflyer's formula works on my side once semi colons are replaced with commas …​

​

Thanks Marc for pointing this out