Converting hijri date to gregorian date

  • Thread starter Thread starter Ramil Marbella
  • Start date Start date
R

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,
 
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,
Click to expand...

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
 
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
 
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 "
 
Back
Top