Japanese date calendar.

This calendar object is already pre-programmed with holiday dates.

You can view the list of holidays between any 2 dates by executing the function GetHolidayList(). There are 2 additional optional parameters that can be used to fine tune the holiday list.

You can provide a range object in order to extend the holiday list with further dates.

You can also provide a range object with a list of dates which will be removed from the holiday list.

The dates passed into these range objects must be in the serial date format (Integer values).

Excel automatically passes dates entered into Excel spreadsheets in this serial date format.

The internal holiday dates are : Saturdays; Sundays; New Year's Day, January 1st; Bank Holiday, January 2nd; Bank Holiday, January 3rd; Coming of Age Day, 2nd Monday in January; National Foundation Day, February 11th; Vernal Equinox; Greenery Day, April 29th; Constitution Memorial Day, May 3rd; Holiday for a Nation, May 4th; Children's Day, May 5th; Marine Day, 3rd Monday in July; Respect for the Aged Day, 3rd Monday in September; Autumnal Equinox; Health and Sports Day, 2nd Monday in October; National Culture Day, November 3rd; Labor Thanksgiving Day, November 23rd; Emperor's Birthday, December 23rd; Bank Holiday, December 31st; A few one-shot holidays.

Holidays falling on a Sunday are observed on the Monday following except for the bank holidays associated with the new year.

This function creates an object and returns a string-key value to represent this created object.
The TAG value of the string-key returned (second part of the key) is : "Japan"

String CTCalendars.CALJapan( _
String Key, _
Long Reload, _
Variant AddHols, _
Variant RemoveHols)

=CT.CAL.Japan(
Excel String Cell Key,
Excel Numeric Cell Reload,
XLRange AddHols,
XLRange RemoveHols)

static std::string CALJapan(
std::string Key,
long Reload,
CTRangeDataCPP AddHols,
CTRangeDataCPP RemoveHols);

System.String CTCalendarsSA.CALJapan(
System.String Key,
System.Int32 Reload,
CTRangeData AddHols,
CTRangeData RemoveHols);

CTQL.CTRangeData CALJapan_AddHols;


int[] arrBCALJapan_AddHols = {
CTQL.Date.serialNumber("1/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("2/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("3/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("4/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("5/2/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("6/2/2006", "dd/mm/yyyy")  //  Array Data

};

CTQL.IntVector arrCALJapan_AddHols =
new  CTQL.IntVector(arrBCALJapan_AddHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALJapan_AddHols = new  CTQL.CTRangeData(arrCALJapan_AddHols, false);

CTQL.CTRangeData CALJapan_RemoveHols;


int[] arrBCALJapan_RemoveHols = {
CTQL.Date.serialNumber("25/12/2006", "dd/mm/yyyy"),
CTQL.Date.serialNumber("25/12/2007", "dd/mm/yyyy")  //  Array Data

};

CTQL.IntVector arrCALJapan_RemoveHols =
new  CTQL.IntVector(arrBCALJapan_RemoveHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALJapan_RemoveHols = new  CTQL.CTRangeData(arrCALJapan_RemoveHols, false);

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.