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.
You could use `WORKDAY()` to get a date 65 workdays after your start date?
I'm not 100% sure that's what you're trying to achieve though. Another interpretation was: It feels like you may have one record per objective, with a set number of days each objective takes to accomplish, and you wish to calculate each objective's completion date based on the start date?