Converting Hijri Date to Gregorian Date from another cell

**brmuse1** · 04-19-2014, 10:51 AM

Hi,
This is my first Forum and I am an intermediate Excel user at best so please bear with me... I have a spreadsheet where we will be inserting the Arabic Hijri date taken from a Customs document (bayan). On my spreadsheet I'd like to have a column immediately next to the Hijri date that would convert the Hijri date to the Gregorian date so both dates will be visible for our Arabic and Western personnel who will be using the spreadsheet.

I am using Microsoft Excel 2010.

Is this possible?

Thank you,

Bret

**shg** · 04-19-2014, 11:17 AM

See http://support.microsoft.com/?scid=kb;EN-ME;871138

**brmuse1** · 04-20-2014, 12:41 AM

Shg,
I appreciate your prompt reply but the article provided information I already knew. Perhaps I was not clear, I want to enter the Hijri date in column A and then have a column B which will automatically convert the Hirji date in column A into the Gregorian date.

Thank you,
Bret

**shg** · 04-20-2014, 12:46 AM

Did you read this part?

Type a date in a cell in Hijri format.

The following method will work only on Arabic Office SKU.
To enable this method for non Arabic SKU’s; you will need to add the following registry key:

HKCU\Software\Microsoft\Office\11.0\Excel\Options\

Value = xl9_hijri
Value Type = DWORD
Value Data = 0

To enter Hijri date, type A or a in front of the date entry.

For example, you can enter the short date 'a9/25/20', which will be interpreted as Hijri date 9/25/1420 (this is Gregorian date 1/1/2000). If the cell is unformatted, it will be assigned the number format 'B2m/d/yyyy' and the value will be displayed as '9/25/1420' Note Your regional settings affect how Excel recognizes the day, month and year parts of the value entered. For example, when using English (United States) regional settings, you should enter the Hijri value as 'a9/25/20'. When using Arabic (Egypt) regional settings, you should enter the Hijri value as 'a25/9/20'