I would like to count the number of Mondays, Tuesdays, etc between 2 dates (including start and stop dates) and excluding Holidays listed in a separate table. This is an example of the output I'd like.
I've found a lot of custom functions that return the total number of days, excluding weekends or excluding holidays but I haven't found anything that will show a count of the number of days by day of the week.
FYI - this is to create a schedule of classes held on one or more days every week and that span several months. I want to account for the fact that some months have 5 Mondays (for example) while others don't.
Anyone have any experience doing something like this?