How do we get the weekdays in a month?

Question

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

quickbasecoachd · Answer

Assuming that you have a date field to indicate the month,  ToDays(LastDayOfMonth([My date field]) -FirstDayOfMonth([My date field]))  + 1

marypearl · Answer

should I create a 2 date field ?

quickbasecoachd · Answer

sorry, I am not understanding your question.You asked how many weekdays there are in a month. &nbsp;Which month?Maybe it's good enough to use 365.25 / 12 = on average 30.4 days in a month.

tonygonzalez · Answer

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

Forum Discussion

How do we get the weekdays in a month?

4 Replies