hijri

Dear Valued Members of Mr.Excel, I hope everyone are safe with the Epidemic of Covid19. I have a huge data set I need to convert as well as sort related to very old Date Info on Hijri, Most dates are either below Hijri year 100 and around the year 100-200, I need aging to be done as well. I...

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...

I used custom format ([$-1970000]B2dd mmmm yyyy;@) to be able to enter the date value in Hijri Calendar, but when i use pivot table and try to group according to date, i found the date grouping is based on Gregorian Calendar. My question is; possibility of grouping date based on Hijri calendar...

Found very useful code to convert Hiiri to Gregorian dates on http://www.islamicsoftware.org/ I found another function which calculates date of Eid Al Adha as a Hijri date. The two functions aside work fine, however if I try to use the code to convert the Hijri date of Eid Al Adha to a...

On column F I have list of expiry dates of residence ID, and they are all in Hijri. I want to automatically have a conversion to be displayed on its adjacent cell on column G to Gregorian. I search this site for similar post and solution but most of them are for older version of Excel.

I have a column of dates on Column F(Gregorian) and it displays the Hijri dates on Column G. What is did is i formatted the all the cells Column G into Home -> Number -> DropDown More Number Formats -> Number -> Category -> Date -> Locale(Location) -> Arabic (Saudi Arabia) Then i just entered...

Respected Members, First of all, I want to thank everyone contributed to this forum. So much I learned for you! Hope you can help me on below issue I searched on the net and here in the forum and found several suggested solutions. Yet, none of it worked for me! When I use function today()...