I have a table called ongoing classes, which has Lessons inside it, we need to make a lesson calendar.
Each class has a column called [Class Days] which lists the days of the week that class will be held, you can have "Monday", "Friday", "Saturday"
Each class has a [Start Date] and an [End Date], which are the start and end date, they can last from one month to 18 months.
I need to create a calendar view that shows all the days that there will be class.
We need to have a column that lists dates, calculated from the [Class days] that are within the [Start Date] and [End Date]
User | Count |
---|---|
15 | |
9 | |
9 | |
7 | |
3 |