I need Convert date from Gregorian Calendar to Hijri Calendar in my worksheet
I need Convert date from Gregorian Calendar to Hijri Calendar in my worksheet
There is a small code that I found which can help you. Try it out. Copy the two functions in a module.
Code:Function HIJRIDATUM (As Date) As String VBA.Calendar = vbCalHijri HIJRIDATUM = Date VBA.Calendar = vbCalGreg End FunctionCode: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
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
Bookmarks