C# .NET - convert the hijri date to gregorian

Asked By Abdul Baseer on 08-Dec-09 01:28 AM

good evening,
How can i make a formula to automatically convert the hijri date to
gregorian date in excel

A                   B
21/11/2025       11-nov-09
i want to type the hijri date in column A, then automatically convert this
date into Gregorian date.

 Someone helfp me plss!!!!!!!!!!!!
Thank you very much in advance,

here

Santhosh N replied to Abdul Baseer on 08-Dec-09 01:51 AM

you could check here for the solution on how to convert ..

http://www.excelforum.com/excel-programming/572150-gregorian-date-from-hijri.html

this is the code

Lakshmi s replied to Abdul Baseer on 08-Dec-09 01:53 AM

Sub islamic_civil(ByRef iYear As Integer, _
                       ByRef iMonth As Integer, _
                       ByRef iDay As Integer)
    Call jdn_civil(islamic_jdn(iYear, _
                               iMonth, _
                               iDay), _
                   iYear, iMonth, iDay)
End Sub

Lakshmi s replied to Abdul Baseer on 08-Dec-09 01:54 AM

you can find all date convertions in

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

shafqat manzor replied to Abdul Baseer on 03-Apr-12 01:46 AM

end of post