Working Day Master Calendar

    There is quite a lot of information on Master Calendars elsewhere in the posts especially determining minimum and maximum dates from the main data to set the master calendar range.

     

    Attached is a variation of the theme which builds a master calendar but only for the main working days (i.e. excludes Saturdays and Sundays)

     

    A further modification would be to incorporate a bank holiday file for exclusion. This could utilize the where not exists functionality.