I have a course of instruction which is 65 days long. Inside of each day I have specific learning objectives to accomplish. Currently my objective table links to a course flow table which is 65 days of training. Along with these 2 tables is an instructor table and a table which covers the 20 teams we have coming through the course’s start date and graduation date for this fiscal year. My question, is there an easier way to populate in a calendar the 65 days of training for each team to be only on week days based off the start and graduation date table? I have tried creating a specific table addressing every day of the week, however it is quite time consuming especially when dealing with 20 different teams each covering 65 days of training. Thank you for your time.
