Convert Between Hijri and Gregorian Dates in Excel

Hijri and Gregorian Dates

Excel can show any date in the Hijri or Umm al-Qura calendar without changing the date itself. Use a number format to display it, or the TEXT function to write the Hijri date into another cell, next to the Gregorian one. Works inExcel 2010 and later, Windows. Excel for Mac supports fewer calendar options CalendarsHijri … Read more