sccardais

Count Day Names between 2 dates

Discussion created by sccardais on Jun 28, 2016
Latest reply on Jun 28, 2016 by siplus

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?

Outcomes