formatting a hijri date

**anne.marian** · 10-31-2014, 06:07 AM

hi guys,
i had a problem on hijri date.when i formatting the cell(b2) like this-b2dddd,mmm yyy, it showed a hijri date according to A1.the problem is the hijri date is one day ahead and it should be 7th.please help.hijcalendar.xlsx

**samba_ravi** · 10-31-2014, 06:21 AM

B1=a1-1 try this

**Glenn Kennedy** · 10-31-2014, 06:22 AM

Have you looked at this article?

http://support.microsoft.com/kb/871138

**anne.marian** · 10-31-2014, 06:33 AM

nfsales,it works on the date but it shown thursday instead of friday...is anybody would solve this problem?

**Bobsone** · 10-31-2014, 06:35 AM

Hi
Just a quick question;
When you wrote "...it showed a hijri date according to A1.the problem is the hijri date is one day ahead and it should be 7th.please help."
Why do you want it to show the 7th

Perhaps I have misunderstood or made some error, but, doesn't the Gregorian calendar date Friday the 31st of October 2014 equate to Muharram the 8th 1436?

Regards.

**anne.marian** · 10-31-2014, 06:47 AM

bobsone,
hijri calendar is different by countries according to moon movement in counting days.some nation would count it one day ahead, while other one day before.

**Bobsone** · 10-31-2014, 08:23 AM

Hi

I think I have come up with a solution to your problem...

I made two helper (I4 and I6) cells each holding a Text version of an aspect of Hijri date.

Have a look at the value in H5, I think it looks correct, the date in A1 can be changed by altering the value in A3.

Regards.