Hello everyone
There is the function DateSerial that convert text to dates
I have in range("C1") the text 
110215
And I used the following line of code to get the date
Range("D1") = DateSerial(Val(Mid(Range("C1"), 5, 2)), Val(Mid(Range("C1"), 3, 2)), Val(Mid(Range("C1"), 1, 2)))
This is for Gregorian dates .. What about Hijrii dates?
If I have this text in C1
261036
I need to have the final result in D1 as follows
26/10/1436
and at the same time to be valid date not just a text

Thanks advanced