Monthly Net Working Days

You might have to modify your dataset first, as you'll need to have all of the dates in your data if you want to calculate before the end of the month. I would probably start in Magic ETL with the Domo calendar dataset, via the Domo Dimensions connector, filtering it down to the appropriate date frame, and then left joining your dataset to it on your date field. This would keep all of the dates in the calendar intact. Then you could write a beast mode to count the Net Working Days, something like:

count(distinct case when dayName != 'Sunday' then dt end)

I did something very similar, and I built it all entirely off of the Calendar Dataset. Ill walk you through how I did it at a high level and if you need clarification let me know. I'm also sure there are better ways but it took me a minute to get this working.

I first used a case statement to assign the dates that I want for our fiscal months to the correct months. Our Months ends 3 days before the month is over.
(Example)
WHEN New Date 1 <'2024-06-26' AND New Date 1 > '2024-05-28' THEN '2024-06-01'

I did this for the whole year. From there I entered in our holidays in a different formula tile and assigned them a number . For example if a holiday falls on a Monday, I would assign it 3(taking it to Friday) since we dont work on weekends.

WHEN New Date 1= '2023-05-29' THEN 3

After That I used date_sub to manipulate the date field. All this does is assign the date to the most recent work day
WHEN New Date 1= '2024-05-27' THEN DATE_SUB(New Date 1, INTERVAL (Holiday) Day)

From there I used a rank and window function the get the count of days. I used a group by to get the max Workdays in each month and joined it back.

Here is what my outputted Dataset looks like. It has the actual workdays, Max weekends in the month, along with max workdays.
Hope this help.