Hijri Date to Gregorian ( vise-versa ) below Hijri Year 100

[Please_H]

Dear Valued Members of Mr.Excel,

I hope everyone are safe with the Epidemic of Covid19.

I have a huge data set I need to convert as well as sort related to very old Date Info on Hijri,
Most dates are either below Hijri year 100 and around the year 100-200, I need aging to be done as well.
I would appreciate if i can find a Macro/ rooted to work like a function solution.

Can anyone help me to find a solution?

I need to change some dates from Gregorian to Hijri as well and those Hijri years go below 100 as well.

Stay safe everyone...

 

[jasonb75]

See if this thread helps, there appears to be a lengthy discussion there but I haven't read the thread in detail.

Hijra Date into Gregorian

Hi there, How i can convert Hijra (Islamic) Dates into Gregorian? a formula or VB any help

www.mrexcel.com

 

[mole999]

Not sure if this helps >

I seem to recall that in the gregorian calender below a certain year it has to be done as text as excel has no idea about those dates

 

[Please_H]

See if this thread helps, there appears to be a lengthy discussion there but I haven't read the thread in detail.

Hijra Date into Gregorian

Hi there, How i can convert Hijra (Islamic) Dates into Gregorian? a formula or VB any help

www.mrexcel.com

I am using the office version 2019 and I am not sure why I am getting an error message as #VALUE!

My Gregorian dates goes as ;
ex : ( dd/mm/yyyy )
01/08/1791

My Hijri dates goes as ;
ex : ( dd/mm/yyyy )
01/08/100
01/08/77
01/08/89

 

[Please_H]

Not sure if this helps >

I seem to recall that in the gregorian calender below a certain year it has to be done as text as excel has no idea about those dates

I actually watched this video....
Didn't want to experiment and mess with the registers and stuff to see if it works...

 

[Please_H]

I came across an excel done by a user known as Hanseljose, even he had commented on the above thread posted by jasonb75, that excel is locked and the vb editor cannot be accessed. Plus it only calculates upto Hijri year 100 or above

 

[jasonb75]

I am not sure why I am getting an error message as #VALUE!

Which post(s) did you try from that thread?

 

[Please_H]

Which post(s) did you try from that thread?

The VB written by Andrew

 

[Please_H]

No solutions guys?

 

[jasonb75]

Not without seeing the workbook.

Try going back and reading the thread that I linked to again from the beginning, as far as I can see the vba was to fix some formatting issues identified around post 3 or 4.

If you can't get what you need from that thread then I suggest copying some of your dates (10 - 20) into a blank workbook (copy and paste to preserve original formatting, not retype), then enter what you want to see in the next column.