Results 1 to 3 of 3

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

  1. #1
    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

  2. #2
    Join Date
    Jul 2011
    Posts
    623

    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

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    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

Similar Threads

  1. Replies: 4
    Last Post: 01-04-2012, 12:24 PM
  2. How to convert a Julian to Gregorian date in Microsoft Excel
    By DawnSet in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 07:45 PM
  3. Replies: 5
    Last Post: 23-04-2011, 10:19 PM
  4. Replies: 3
    Last Post: 18-10-2010, 12:12 PM
  5. Replies: 9
    Last Post: 25-10-2009, 01:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,691,264.92228 seconds with 17 queries