This content has been marked as final. Show 2 replies
I have a dashboard I'm building where I need to calculate hours utilization by month. The calculation needs to take into account only weekdays and needs to exclude holidays. The difficulty I'm running into is the only dates I have available to use is every Sunday (week starting). I created the following calculated fields to create the beginning and end of the applicable month;
And count the number of weekdays using this calculation;
All that gives me the right number of weekdays. But, after that I'm stumped on how to remove the below listing of holidays. If I had an actual effective date, instead of a week starting date for each transaction, I could easily add these holidays in to my report and filter them out. Any ideas?
|1/1/2019||New Years Eve|
|12/30/2019||New Years Eve|
|12/31/2019||New Years Eve|