Forum Discussion

MaryPearl's avatar
MaryPearl
Qrew Member
7 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? 

4 Replies

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

    ToDays(LastDayOfMonth([My date field]) -FirstDayOfMonth([My date field])) + 1
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      sorry, I am not understanding your question.

      You asked how many weekdays there are in a month.  Which month?

      Maybe it's good enough to use 365.25 / 12 = on average 30.4 days in a month.
    • TonyGonzalez's avatar
      TonyGonzalez
      Qrew Trainee

      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.)