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.
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.
Assalamualaikum
nice post
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
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks