How to convert Hjri date to Gregorian

Gohar Shahab

Active Member
Joined
May 17, 2006
Messages
339
Excel converts Gregorian dates to Hijri dates by using the date format "B2dd/mmm/yyyy". How to convert Hijri date to Gregorian date?"

Gohar
Using XL 2003
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hi Gohar, please explain how Excel converts dates this way? I understood that Hijri dates were a Windows setting.
 

Gohar Shahab

Active Member
Joined
May 17, 2006
Messages
339
GlennUK

In excel 2003 format a cell with B2dd/mmm/yyyy, you will get your date in the cell converted to hijri date.

Gohar
Using XL 2003
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hi again Gohar, thanks, I also found the MS article about the number format you've shown. That shows a Gregorian date as Hijri, so to convert back you'd just change the number format. According to the article:
http://support.microsoft.com/?scid=kb;EN-ME;871138
you can enter a Hijri date in a cell like this:
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
which of course can be formatted as Gregorian if you want to see what the Gregorian date is.
 

Forum statistics

Threads
1,141,203
Messages
5,704,931
Members
421,372
Latest member
Jamie11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top