Date converter from Hijri to Gregorian celender

[NDMDRB]

Hello,

Please I need you help with this equation

I have Excel Sheet with Hijri Dates and I want to convert them to Gregorian
I tried the below equation and worked but not able to convert all the cells one time, I have to manually input the equation on each cell to get what I need
Can you please provide me another way to convert the dates for all the requested cells together? Without using macro

The format i'm usingchange the format for the cell (Hijri Date) and then on another cell I put equal the cell that has Hijri Date, I got what I want but this way, I should put it for each cell
[$-1970000]B2mm/dd/yyyy;@

Regards

 

[mole999]

does the formula not drag down ?

 

[footoo]

If the cells containing the Hijri dates are in date format, it is just a matter of reformatting the cells to a Gregorian format.
https://support.microsoft.com/en-us...er-and-use-hijri-date-in-microsoft-excel-2003