Convert Gregorian date to Hijri date by VBA

[Mohammed9877]

How do you convert Gregorian dates to Islamic Hijri dates using JavaScript?

I would like a code that convert Gregorian date to hijri date in excel through VBA

I didn't know how to do it. I need it cuz my laptop couldn't do it

 

[Micron]

VBA is not Javascript so which is it that you would want? I know nothing about Hijri dates but found this conversion formula

Hijri Date Conversion

IHAMS is the Institute for History of Arab-Islamic Medicine and Sciences

ihams.co.uk

If it is useful, you could use that as a formula in spreadsheet cells, or you could use vba to perform the same calculation on that cell or another cell based on the G date. VBA seems like overkill if it's as simple as what that website shows.

 

[Mohammed9877]

v

 

[Mohammed9877]

VBA is not Javascript so which is it that you would want? I know nothing about Hijri dates but found this conversion formula

Hijri Date Conversion

IHAMS is the Institute for History of Arab-Islamic Medicine and Sciences

ihams.co.uk

If it is useful, you could use that as a formula in spreadsheet cells, or you could use vba to perform the same calculation on that cell or another cell based on the G date. VBA seems like overkill if it's as simple as what that website shows.

thank you so much