Automated Annual Calendar Gregorian Hijri

[IMA_Saihat]

I would like to share with you the attached Automated Annual Calendar Gregorian Hijri, which I prepared using Excel Formulas & Functions.
Please post your questions and remarks.

[azumi]

Assalamualaikum

nice post

[IMA_Saihat]

Hi,
Attached is Annual Calendar (Gregorian and Hijri)for the period 2000 to 2030 on PDF file that I created from my Excel file (Automated Annual Calendar Gregorian Hijri) for your easy reference.

Thanks.

IMA_Saihat
Annual_Calendar_Gregorian_Hijri_Years_2000-2030.pdf

[BlindAlley]

Excellent Calendar.

An add on if you want an automatic year change.

If you add 4 hidden cells with the following formulas you can turn this into an actual perpetual calendar which doesn't require a date change for a new year.

Presuming AB1 is where the hidden cell will be:

AB1) =TODAY()
AB2) =YEAR(AB1)
AC2 Enter) 1
AB3) =DATE($AB$2,$AC$2,1)

In the 'Change Year cell enter , =AB3 formatted to just 'yyyy. Every January the 1st the calendar will change to the New Year.

[azumi]

Hi Saihat

I like share mine too, Its been a while Im making this date conversion, gregorian date to hijri date and hijri to gregorian,
hope you like it

regards

[IMA_Saihat]

Hi, BlindAlley

Thank you for your suggestion to revise my posted calendar into current year calendar, which does not require a date change for a new year. Attached is the "Revised Automated Annual Calendar Gregorian Hijri" for your reference.

Best regards.

IMA_Saihat

Revised_Automated_Annual_Calendar_Gregorian_Hijri.xlsx