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

 

[Please_H]

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.

How do we attach a workbook bro?

 

[jasonb75]

Sorry, thought I had said in my reply, you can either use the xl2bb add in (green button on reply box toolbar) or upload it to a file share service then post the link.

 

[Please_H]

Sorry, thought I had said in my reply, you can either use the xl2bb add in (green button on reply box toolbar) or upload it to a file share service then post the link.

No need to say sorry Man...
you've gone outta your way to help me out.
Much love for that...

Didn't have time to wait for a solution cz I was running against time....
Found a calculator Hijri to Gregorian and vise versa. Took the measure to type them with the help of the UDF found in the last post in the below thread.
I will be out with few days...But I am more interested and concerned with years and the below helped me to sort it out.

Wasn't a direct way though, but a work around.

Thanks again.
stay safe and tc.

Gregorian Period 100-1900 and Aging