Converting hijri date to gregorian date

[Ramil Marbella]

good evening,
How can i make a formula to automatically convert the hijri date to
gregorian date:
A B
21/11/1430 11-nov-09
i want to type the hijri date in column A, then automatically convert this
date into Gregorian date or calendar. Someone helfp me plss!!!!!!!!!!!!

Thank you very much in advance,

 

[Ron Rosenfeld]

On Mon, 9 Nov 2009 06:59:03 -0800, Ramil Marbella <Ramil

good evening,
How can i make a formula to automatically convert the hijri date to
gregorian date:
A B
21/11/1430 11-nov-09
i want to type the hijri date in column A, then automatically convert this
date into Gregorian date or calendar. Someone helfp me plss!!!!!!!!!!!!

Thank you very much in advance,

The various web sources I accessed indicate that the conversion should be 9
November 2009, as does a converter written for Excel.

====================================
Calendar Math v1.2

By Kees Couprie

Calendar Math is freeware.
The reason for writing this Excel Add-In was to promote inter-religious
understanding and tolerance.

For more information, surf to the Calendar Math web site

"http://calmath.couprie.org/index.html"

================================================
--ron

 

[Nabil Rafla]

I have the same problem.

Please let me know if you get an answer.

Many thanks



Ramil Marbella wrote:

Converting hijri date to gregorian date
09-Nov-09

good evening
How can i make a formula to automatically convert the hijri date t
gregorian date
A
21/11/1430 11-nov-0
i want to type the hijri date in column A, then automatically convert thi
date into Gregorian date or calendar. Someone helfp me plss!!!!!!!!!!!

Thank you very much in advance,

Previous Posts In This Thread:

Converting hijri date to gregorian date
good evening
How can i make a formula to automatically convert the hijri date t
gregorian date
A
21/11/1430 11-nov-0
i want to type the hijri date in column A, then automatically convert thi
date into Gregorian date or calendar. Someone helfp me plss!!!!!!!!!!!

Thank you very much in advance,

The various web sources I accessed indicate that the conversion should be
The various web sources I accessed indicate that the conversion should be
November 2009, as does a converter written for Excel

===================================
Calendar Math v1.

By Kees Coupri

Calendar Math is freeware
The reason for writing this Excel Add-In was to promote inter-religiou
understanding and tolerance

For more information, surf to the Calendar Math web sit

"http://calmath.couprie.org/index.html

===============================================
--ron


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Conditional looping incorporating the Greater Than functoid.
http://www.eggheadcafe.com/tutorial...2d-043c18df964c/biztalk-conditional-loop.aspx

 

[Luke M]

For the gregorian date, simply have it reference the source cell, but change
the formatting of cell to custom:
B1dd-mmm-yy

From XL help file "Format dates using alternate calendars "

 

[hanseljose]

I have created a excel file with macro which will convert the Hijri date to Grogorian . If anyone need this file , please mail to me hanseljose(gmail.com)