Forum Discussion

EmWy24's avatar
EmWy24
Regular Visitor
2 years ago

Workdays in current Month

I am trying to work out the number of work days in the current month.   I have a formula which works to show number of days in month, but how do I change this to just show weekdays?   DAY(DAY(EO...
pbiuseruk's avatar
pbiuseruk
Icon for Resolver IV rankResolver IV
2 years ago

Hi,

 

Please try this - just tried it and it works for me.

CM_WorkdaysInCurrentMonth = 
var start_of_current_month = EOMONTH(today(),-1) + 1
var end_of_current_month = EOMONTH(today(),0)
var calender_month_days = Filter(CALENDAR(start_of_current_month,end_of_current_month), WEEKDAY([Date],2)<6)
RETURN
COUNTROWS(calender_month_days)