Date Converter from English Date to Hijric Date in Excel ?

[Baazigar]

Date Converter from English Date to Hijri Date in Excel ?

Dear Experts !

I have two coloums in Excel Sheet,

I need to Enter Dates in Two Coloums.

In Coloum English Date & in another Coloum Hijri Date.

What I need, when I enter Date in English Date coloum , the other Date Coloum (Hijri Date ) should be change automatically.

Please can any one help me.

Allah Haafiz,

[Baazigar]

Date Converter from English Date to Hijri Date in Excel ?

Dear Experts !

I have two coloums in Excel Sheet,

I need to Enter Dates in Two Coloums.

In Coloum English Date & in another Coloum Hijri Date.

What I need, when I enter Date in English Date coloum , the other Date Coloum (Hijri Date ) should be change automatically.

Please can any one help me.

Allah Haafiz,

Any body can help me, please .........

[Baazigar]

Date Converter from English Date to Hijri Date in Excel ?

Dear Experts !

I have two coloums in Excel Sheet,

I need to Enter Dates in Two Coloums.

In Coloum English Date & in another Coloum Hijri Date.

What I need, when I enter Date in English Date coloum , the other Date Coloum (Hijri Date ) should be change automatically.

Please can any one help me.

Allah Haafiz,

Nobody Can Answer my Problem ???????????

[notme]

yahan say convert ker lain

http://www.muslimphilosophy.com/ip/hijri.htm

http://www.islamicfinder.org/Hcal/index.php

[Baazigar]

yahan say convert ker lain

http://www.muslimphilosophy.com/ip/hijri.htm

http://www.islamicfinder.org/Hcal/index.php

Excel Sheet mein convert karna hai ?

[syar]

salam::

See if this could help you

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

regards

[*Sahir*]

Date Converter from English Date to Hijri Date in Excel ?

Dear Experts !

I have two coloums in Excel Sheet,

I need to Enter Dates in Two Coloums.

In Coloum English Date & in another Coloum Hijri Date.

What I need, when I enter Date in English Date coloum , the other Date Coloum (Hijri Date ) should be change automatically.

Please can any one help me.

Allah Haafiz,

1. On the Format menu, click Cells, and then click the Number tab.
2. From the Type list select the Hijri format that you want to use and press OK, or continue to proceed in the next steps (Step 3)
. Select Custom from the list of categories.
. In the Type box, do one of the following:
. B1dd/mm/yy - To display dates using the Gregorian calendar, regardless of the Regional Options or Regional Settings of the Microsoft Windows Control Panel setting, type B1 before the date format.
. B2dd/mm/yy – to type the date in Gregorian format but it will be interpreted and displayed as Hijri date.

[Baazigar]

1. On the Format menu, click Cells, and then click the Number tab.
2. From the Type list select the Hijri format that you want to use and press OK, or continue to proceed in the next steps (Step 3)
. Select Custom from the list of categories.
. In the Type box, do one of the following:
. B1dd/mm/yy - To display dates using the Gregorian calendar, regardless of the Regional Options or Regional Settings of the Microsoft Windows Control Panel setting, type B1 before the date format.
. B2dd/mm/yy – to type the date in Gregorian format but it will be interpreted and displayed as Hijri date.

Can u please show me in MS Office 2007

I dont have Ms Office 2003

[*Sahir*]

اسلام و علیکم ورحمتہ اللہ
قابل احترام دوست میں آپ کوسکرین شاٹ دے رہا ہوں اُمید ہے آپ کو سمجھ آ جائے گی
شکریہ

[Baazigar]

اسلام و علیکم ورحمتہ اللہ
قابل احترام دوست میں آپ کوسکرین شاٹ دے رہا ہوں اُمید ہے آپ کو سمجھ آ جائے گی
شکریہ

Bahot Shukriya Sahir Bhai ........

Bahot hi umda Tareeqe se Samjhane keliye.

جزاك الله خيراً

[IT.BOY]