LinkBack URL
About LinkBacks
Hi
is there any way in excel to convert from Hijri Date to Gregorian. in column A I have multiple Cells with Hijri Date, in column B a formula to convert the date in column A which is Hijri to be Gregorian
thank you in advance
Hi
is there any way in excel to convert from Hijri Date to Gregorian. in column A I have multiple Cells with Hijri Date, in column B a formula to convert the date in column A which is Hijri to be Gregorian
thank you in advance
Maybe this could help: http://www.excelforum.com/excel-prog...rom-hijri.html
Never use Merged Cells in Excel
thank you for your quick response
but it works only when I convert from Greg to Hirji
when I tried the opposite way, it is not working
I attached a sample of the file
I know cells in column A is not date cells
any way to convert them to dates and then apply
your formula
thanks
You also can type A or a in front of the date entry — for example, enter the short date 'a9/25/20', which will be interpreted as Hijri date 9/25/1420 (this is Gregorian date 1/1/2000).
If the cell is unformatted, it will be assigned the number format 'B2m/d/yyyy' and the value will be displayed as 9/25/1420.
Try the sample code/workbook from this link
http://www.islamicsoftware.org/hijri...ijridates.html
HijriDates.xls
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
I have created a excel file with macro which will convert the Hijri date to Grogorian . If anyone need this file , please mail to me hanseljose@gmail.com
Jose.
Hijri_to_Gregorian_Converter.xlsm
Last edited by hanseljose; 08-26-2013 at 04:30 AM.
Thank You Very Much.
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks