Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-02-2012
Member
 
Join Date: Jan 2012
Posts: 23
How to convert date from Gregorian Calendar to Hijri Calendar in Excel

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

Reply With Quote
  #2  
Old 07-02-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: How to convert date from Gregorian Calendar to Hijri Calendar in Excel

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 Function
Code:
 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
Reply With Quote
  #3  
Old 07-02-2012
Member
 
Join Date: Aug 2011
Posts: 564
Re: How to convert date from Gregorian Calendar to Hijri Calendar in Excel

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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert date from Gregorian Calendar to Hijri Calendar in Excel"
Thread Thread Starter Forum Replies Last Post
My calendar and Google calendar is not synced any more in Motorola DROID XYBOARD 8.2. Daniel90 Portable Devices 4 01-04-2012 12:24 PM
How to convert a Julian to Gregorian date in Microsoft Excel DawnSet MS Office Support 2 03-02-2012 07:45 PM
Rather than showing current date / calendar month, Microsoft calendar gadget is displaying a blank page Mustaffa Windows Software 5 23-04-2011 10:19 PM
Windows Live Mail calendar doesn't sync entries to the online calendar Koena Technology & Internet 3 18-10-2010 12:12 PM
How move XP outlook calendar data to Vista Windows Calendar Ken H Vista Help 9 25-10-2009 01:25 AM


All times are GMT +5.5. The time now is 12:56 AM.