How do we get the weekdays in a month?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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? 
Photo of Mary Pearl

Mary Pearl

  • 50 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Assuming that you have a date field to indicate the month,

ToDays(LastDayOfMonth([My date field]) -FirstDayOfMonth([My date field])) + 1
Photo of Mary Pearl

Mary Pearl

  • 50 Points

should I create a 2 date field ?

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
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.