Discussions

 View Only
  • 1.  How do we get the weekdays in a month?

    Posted 07-20-2017 09:07
    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? 


  • 2.  RE: How do we get the weekdays in a month?

    Posted 07-20-2017 11:36
    Assuming that you have a date field to indicate the month,

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


  • 3.  RE: How do we get the weekdays in a month?

    Posted 07-20-2017 12:07

    should I create a 2 date field ?



  • 4.  RE: How do we get the weekdays in a month?

    Posted 07-20-2017 12:31
    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.