Hello,

I need your help in creating a calendar that converts the dates from Gregorian Calendar to Afghani Calendar. Afghani Calendar is solar calendar which mean it has 365 days. It is not Lunar Calendar. So year 2006 = 1385 afghani calendar. So this mean that G= A + 621 and A= G- 621.

The problem I have is converting the months and days. The new year for Afghani Calendar is march 20 or 21 (depends on which day is the first day of spring). So the new year 1/1/2006 is 3/20/1385.

I would like to create a excel file that does this conversion and as well show the month and days graphically.