Hijra Date into Gregorian

[Ahmad.Khattab]

Hi there,

How i can convert Hijra (Islamic) Dates into Gregorian?

a formula or VB

any help

 

[Andrew Poulsom]

Press Alt+F11 to open the Visual Basic Editor. Select your workbook in the window on the left and choose Insert|Module from the Menu. Paste the code into the window on the right. Press Alt+F11 to return to your workbook, press Alt+F8 to show the Macros dialog, select the macro Test and click Run.

 

[JedHeart]

Mr. Andrew Poulsom

Thanks the info. But is there no other way formula to show up input the cell? For example Column A Text input the Arabic number and the Text Column B is number of conversation and even how many rows to input the numbers.

Column A (Hijri) Column B (Gregorian)

1439/10/26 10-July-2018


Bert
Norberto.Ronquillo@interserveme.com

 

[Andrew Poulsom]

There is no built-in function to convert a Hijri date to Gregorian if that's what you mean. How did you enter the dates in column A? You can enter Hijri dates if the cell is formatted appropriately as shown here:

https://support.microsoft.com/en-us/kb/871138