Business_Date_Add

Purpose

Calculates business days in a flexible manner.

Arguments

Business_Date_Add(

<File_Name>
//The MDB to be used. Works identical to tbl_Lookup functions.
, <Table_Name>
//The table within the MDB to be used. If empty, then no table is used. The table contains a list of holidays (non-business days).
, <Col_Name>
//The optional name of a Yes/No column to be checked within <Table_Name>. If empty, then record existence is taken to mean True (treat it as a non-business day).
, <Start_Date>
//The date from which to calculate a number of business days.
, <Days>
//The number of business days to add.
, <Day_List>
//A string of seven (7) characters with positional correspondence to Sunday through Saturday. A "B" in any position means that it is a normal business day. A "C" in any position means that it is a conditional business day (delivery is allowed, but it is not counted as a normal business day). Any other character implies it is not a business day.
)

Notes

<table name> parameter has been modified so that either a "Table_Name" "Table_Name:Index_Name" can be used. "Index_Name" is optional. If it is not given (as has been true to this point), then "PrimaryKey" is assumed.

<File_Name>	//The MDB to be used. Works identical to tbl_Lookup functions.
, <Table_Name>	//The table within the MDB to be used. If empty, then no table is used. The table contains a list of holidays (non-business days).
, <Col_Name>	//The optional name of a Yes/No column to be checked within <Table_Name>. If empty, then record existence is taken to mean True (treat it as a non-business day).
, <Start_Date>	//The date from which to calculate a number of business days.
, <Days>	//The number of business days to add.
, <Day_List>	//A string of seven (7) characters with positional correspondence to Sunday through Saturday. A "B" in any position means that it is a normal business day. A "C" in any position means that it is a conditional business day (delivery is allowed, but it is not counted as a normal business day). Any other character implies it is not a business day.