How To Convert Hijri To Gregorian Date Format?

Asked By jeffe meeks 0 points N/A Posted on - 06/19/2017

Is it possible to convert hijri to gregorian date format i.e. the Islamic date format to the widely used format in the Gregorian calendar?

• Status: Open
• Question Views: 806
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: MS excel | settings

Answered By Jack E Morton 20 points N/A #299736

How To Convert Hijri To Gregorian Date Format?

Use the following ways to convert hijri to gregorian:
1. Using Ms-Excel: In the Format Menu, click on Cells. Then, click on Number tab and select Custom under the list of categories. Then, in the Type box type B1 before the date format. This change will display the Gregorian irrespective of the Regional settings. Or type B2 for Gregorian to be displayed and interpreted as Hijri.
2. Using the given link:Click-Here.

3. Using the link:Joda-Time. This link will give you an estimated result.

About Jack E Morton

Questions
8

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/19/2017
• Question Category: MS Excel