US public holidays (see: http://www.opm.gov/fedhol/).

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 (possibly moved to Monday if actually on Sunday, or to Friday if on Saturday); Martin Luther King's birthday, third Monday in January; Presidents' Day (aka Washington's birthday), third Monday in February; Memorial Day, last Monday in May; Independence Day, July 4th (moved to Monday if Sunday or Friday if Saturday); Labor Day, first Monday in September; Columbus Day, second Monday in October; Veterans' Day, November 11th (moved to Monday if Sunday or Friday if Saturday); Thanksgiving Day, fourth Thursday in November; Christmas, December 25th (moved to Monday if Sunday or Friday if Saturday).

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 : "unitedstates"

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

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

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

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

CTQL.CTRangeData CALUSSettlement_AddHols;


int[] arrBCALUSSettlement_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 arrCALUSSettlement_AddHols =
new  CTQL.IntVector(arrBCALUSSettlement_AddHols);

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

CTQL.CTRangeData CALUSSettlement_RemoveHols;


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

};

CTQL.IntVector arrCALUSSettlement_RemoveHols =
new  CTQL.IntVector(arrBCALUSSettlement_RemoveHols);

// Second parameter determines whether the array is a column array (false) or a row array (true)
CALUSSettlement_RemoveHols = new  CTQL.CTRangeData(arrCALUSSettlement_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.