Note: In order to use the spreadsheet examples, you need to download Business Functions
|NetWorkDaysBF (FromDate, ToDate, [WeekendDays], [AnnHols], [HolDates], [BusDaySwitch])|
|Days Elapsed, not counting holidays including the two end dates|
|Works like Excels NETWORKDAYS function, except when one or more the optional variables are specified. It can then take into account non Saturday/Sunday weekends, Annual Holidays, specific holidays and business day conventions.|
|...BF||BF version of an Excel function|
Whats good or unique about it
It"s like Excel"s NETWORKDAYS, but you can set your own weekend days and even have recurring annual holidays as well as specific holiday dates.
Note that the two end dates are included, so in effect its "the days elapsed from the morning of FromDate to the evening of ToDate" Note this one a the few violations of Business Functions general rule "including the FromDate but excluding the ToDate", made necessary by the need to be compatible with Excel.