--------------------------------------------------------------------------------
Yashil's Gregorian date to Jalali date Converter and vice versa (Excel Add-In), Version 1.01

This is the ReadMe.txt file for "Yashil's Gregorian date to Jalali date Converter and vice versa".
I have written it as an Add-In for Microsoft Excel for converting Gregorian date to Jalali date and vice versa.

It 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 help us to add a Jalali date column to our lists.

Hope you will enjoy this.

--------------------------------------------------------------------------------
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".

--------------------------------------------------------------------------------
Usage:

=YfGreg2Jalali(A2, 1)

or

=YfGreg2Jalali(A2, 2)

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

--------------------------------------------------------------------------------
See the "sample.xls" for usage examples.

Here is a sample clip of this file:
--------------------------------------------------------------------------------
Formulas:
Quarter Date (Gregorian)	Date (Jalali, 1)	Date (Jalali, 2)	Days Left
=now()				=YfGreg2Jalali(A2,1)	=YfGreg2Jalali(A2,2)	=A2-TODAY()
=now()+1			=YfGreg2Jalali(A3,1)	=YfGreg2Jalali(A3,2)	=A3-TODAY()
--------------------------------------------------------------------------------
Will look like:
Quarter Date (Gregorian)	Date (Jalali, 1)	Date (Jalali, 2)	Days Left
Sunday, August 10, 2003		1382/05/19		ٍ˜شلبم 19 كرداد 1382		0
Monday, August 11, 2003		1382/05/20		دنشلبم 20 كرداد 1382		1
Sunday, August 17, 2003		1382/05/26		ٍ˜شلبم 26 كرداد 1382		7
Sunday, August 24, 2003		1382/06/02		ٍ˜شلبم 2 شمرٍنر 1382		14
Monday, August 09, 2004		1383/05/19		دنشلبم 19 كرداد 1383		365
Tuesday, August 09, 2005	1384/05/18		سم شلبم 18 كرداد 1384		730
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
List of functions:

YfGreg2Jalali(A1,1)

YfGregYearIsLeap(2005)

YfJalali2Greg(A1)

YfJalaliMonthName(1)

YfJalaliWeekdayName(1)

YfSolarYearIsLeap(1383)

--------------------------------------------------------------------------------
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 YfGreg2Jalali command.

Mahdi Amiri

E-mail: amiri@mehr.sharif.edu
Website: http://ce.sharif.edu/~m_amiri/
or
E-mail: yashil1@yahoo.com
Website: http://yashil.20m.com/

--------------------------------------------------------------------------------