Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    List of Holidays
    List of all the holidays dealt with by BusDaySwitch
    The following list of holidays is used in Business Day calculations.
    Business
    Day
    Switch
    BF
    Holiday
    Number
    UK National
    100

    New Years DayJan 01 (1)1
    Good Friday1st Friday before Easter (1)8
    Easter Monday1st Monday after Easter (1)7
    May Day1st Monday in May (1)2
    Spring Bank Holiday1st Monday before end of May (1)3
    Christmas DayDec 25 (1)5
    Boxing DayDec 26 (1)6
    UK (England+Wales)
    101
    These holidays are in addition to the national holidays

    August Bank Holiday1st Monday before end of August (1)4
    UK (Scotland)
    102
    These holidays are in addition to the national holidays

    Scottish 2nd JanuaryJan 02 (1)39
    Scottish Summer Bank Holiday1st Monday in August (1)40
    UK (Northern Ireland)
    103
    These holidays are in addition to the national holidays

    St Patricks DayMar 17 (1)43
    Battle Of The BoyneJul 12 (1)42
    August Bank Holiday1st Monday before end of August (1)41
    USA (National/NYSE)
    200

    New Years DayJan 01 (2)17
    Luther King Day3rd Monday in January (2)18
    Washingtons Birthday3rd Monday in February (2)38
    Good Friday1st Friday before Easter (2)26
    Memorial Day1st Monday before end of May (2)19
    Independence DayJul 04 (2)21
    Labour Day (US/Can)1st Monday in September (2)22
    Thanksgiving4th Thursday in November (2)24
    Christmas DayDec 25 (2)25
    USA (Federal Gov)
    201
    These holidays are in addition to the national holidays

    Columbus Day2nd Monday in October (1)44
    Veterans DayNov 11 (1)23
    Canada national
    300

    New Years DayJan 01 (1)27
    Good Friday1st Friday before Easter (1)36
    Easter Monday1st Monday after Easter (1)37
    Victoria Day1st Monday before or including May (1)28
    Canada DayJul 01 (1)29
    Labour Day (US/Can)1st Monday in September (1)31
    Thanksgiving Day2nd Monday in October (1)32
    Remembrance dayNov 11 (1)33
    Christmas DayDec 25 (1)34
    Boxing DayDec 26 (1)35
    Australia National
    400

    New Years DayJan 01 (1)9
    Australia DayJan 26 (1)10
    Good Friday1st Friday before Easter (1)15
    Easter Monday1st Monday after Easter (1)16
    Anzac DayApr 25 (1)11
    Queens Birthday2nd Monday in June (1)12
    Christmas DayDec 25 (1)13
    Boxing DayDec 26 (1)14
    Brazil
    500

    New Years DayJan 0145
    Good Friday1st Friday before Easter46
    Labor DayMay 0149
    Christmas DayDec 2547
    Carnaval Day 148 days before Easter50
    Carnaval Day 247 days before Easter51
    Brazilian Independence DaySep 0752
    Our Lady Of AperecidaOct 1253
    Corpus Christi60 days after Easter56
    All Souls DayNov 0254
    Proclamation Of The Republic DayNov 1555
    TiradentesApr 2157
    Footnotes

    (1) Do not move if holiday falls on weekend.

    (2) If on Saturdays and Sundays move forward to Monday

    (3) If on Saturday move back to Friday, if on Sunday move forward to Monday.

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure