Conversion of Hijri Date to Gregorian Date and Vice versa

Hi All,

I need a VBA Coding to convert Hijri date to Gregorian date and vice versa


Thanks in advance..........

This UDF function for converting from Gregorian date to Hijri date

Please Login or Register  to view this content.

And this for the vice versa

Please Login or Register  to view this content.

Hi Yasser,
Thanks for your efforts.

But i found one error in this when i convert Gregorian date to Hijri Date for 06-Apr-2005 it is Giving the Hijri Date as 26-2-1436. But actual Hijri date is 27 on the given date.

Hi,

Any Solution....