Brief Explanation:

"Yashil's Gregorian Date to Jalali Date Converter and Vice Versa" (yfgreg2jalali) have been written as an Add-In for Microsoft Excel. It may be used for converting Gregorian date to Jalali date. This could be useful in various lists where we have a quarter date column. Usually we prefer to use Gregorian date as it later helps us to take advantage of functions provided by Excel, like computing number of days left till the certain date. This Add-In helps us to add a Jalali date column in our lists. Hope you will enjoy it.

Installation:

• Copy "yfgreg2jalali_AddIn_Ver.1.01.xla" to your Microsoft AddIns directory, it is usually C:\Windows\Application Data\Microsoft\AddIns or, if the system is using user profiles, it is C:\Windows\Profiles\UserName\Application Data\Microsoft\AddIns or C:\Documents and
  Settings\UserName\Application Data\Microsoft\AddIns

• Open Microsoft Excel

• Select Tool -> Add-Ins... menu item

• In Add-Ins window select "Yashil's Gregorian date to Jalali date Converter" and press ok or if you have missed the add-ins subfolder in the first step, you may press "browse..." in this window and select "yfgreg2jalali_AddIn_Ver.1.01.xla".

Functions:

• YfGreg2Jalali

• YfJalali2Greg

• YfGregYearIsLeap

• YfJalaliMonthName

• YfJalaliWeekdayName

• YfSolarYearIsLeap

Sample Usage:

The following function could be used for converting Gregorian date to Jalali date.

=YfGreg2Jalali(A2, 1)

or

=YfGreg2Jalali(A2, 2)

where "A2" is the address of a cell with Gregorian date content.

Please see the provided sample excel file in the released pack for other usage examples.

Version History:

• Version 1.01
      - Bug for March 24 and 25 of leap years is fixed in YfGreg2Jalali function.
      - Verified for all dates after January 1, 1600.
      - YfJalali2Greg function is added for Jalali to Gregorian date convertion.
      - YfGregYearIsLeap function is added.
      - YfSolarYearIsLeap function is added.
      - YfJalaliMonthName function is added.
      - YfJalaliWeekdayName function is added.

• Version 1.00
      - Basic conversion function.

Screen Shots:

Figure 1. Sample Excel file which shows how to use yfgreg2jalali.