Forum Discussion

Qrew Member

8 years ago

How do we get the weekdays in a month?

We need to compute for below formula: Utilization % = Total Actual Hour / (Weekdays in a month * 7.5) How do we get the weekdays in a month?

Qrew Captain

8 years ago

Assuming that you have a date field to indicate the month,

ToDays(LastDayOfMonth([My date field]) -FirstDayOfMonth([My date field])) + 1

Qrew Trainee

2 years ago

Thank you for this. I just used this today. (I had NO idea QB even existed 7 years ago. I love that help provided back then is still relevant today.)