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