How to convert date from Gregorian Calendar to Hijri Calendar in Excel

[AsceTic!]

Sponsored Links

I need Convert date from Gregorian Calendar to Hijri Calendar in my worksheet

[Koman]

There is a small code that I found which can help you. Try it out. Copy the two functions in a module.

 Function HIJRIDATUM (As Date) As String 
 VBA.Calendar = vbCalHijri 
 HIJRIDATUM = Date 
 VBA.Calendar = vbCalGreg 

 End Function

 GREG function DATE (HIJRIDATUM As String) As Date 
 Dim i As Date 
 VBA.Calendar = vbCalHijri 
 i = HIJRIDATUM 
 VBA.Calendar = vbCalGreg 
 GREG DATE = i 
 End Function

[AnitG]

You can download a calculator for the process from internet. Just search for Hijri-Gregorian Calendar and Converter. This is a small tool which can help you for the process. Another than this there is a link which has more info on the same.

How to enter and use Hijri date in Microsoft Excel 2003