Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Converting hijri date to gregorian date

3,385 views
Skip to first unread message

Marbella@discussions.microsoft.com Ramil Marbella

unread,
Nov 9, 2009, 9:59:03 AM11/9/09
to

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

unread,
Nov 9, 2009, 4:23:47 PM11/9/09
to

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

nabilrafla

unread,
Mar 30, 2010, 8:17:05 AM3/30/10
to
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

Previous Posts In This Thread:

On Monday, November 09, 2009 9:59 AM
Ramil Marbella wrote:

Converting hijri date to gregorian date

On Monday, November 09, 2009 4:23 PM
Ron Rosenfeld wrote:

The various web sources I accessed indicate that the conversion should be
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


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Conditional looping incorporating the Greater Than functoid.
http://www.eggheadcafe.com/tutorials/aspnet/e4334816-d106-40f2-812d-043c18df964c/biztalk-conditional-loop.aspx

Luke M

unread,
Mar 30, 2010, 8:37:32 AM3/30/10
to
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 "

--
Best Regards,

Luke M
<Nabil Rafla> wrote in message news:20103308174...@hotmail.com...

Taha Lahlou

unread,
May 5, 2021, 5:08:07 AM5/5/21
to
try this
=VLOOKUP(A2;IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bRjd8tBXujn4C1pMi5onqLS8CUQ_Wp9IkW2OkgFQ2nU";"HijriDates!$A$1:$D");3;0)

A2: the date you are looking for
0 new messages