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.