Forum Discussion

JeffBrown1's avatar
JeffBrown1
Qrew Trainee
6 years ago

Duration for Workdays

I need to create a report that reflects the number of Work Days early or late for a project. I have a report now that gives me calendar days based upon the Todays function using Start Date and a Completion Date. I've tried to write a formula based upon the WeekdaySub but with no success.

Any help would be appreciate.

------------------------------
Jeff Brown
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Try this format as a formula numeric field.

    WeekdaySub([End Date], Start Date])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • JeffBrown1's avatar
      JeffBrown1
      Qrew Trainee
      6 years ago
      Thank you for the quick response and that gave me my first answer. Is there a way I can utilize the WeekdaySub to generate a running number when overdue? Current formula looks like this 

      If([Status] = "Completed", null, ToDays(Today() - [Task Due Date])<=0, null, ToDays(Today() - [Task Due Date]))

      I tried just changing the ToDays to WeekdaySub and that was not the answer.

      ------------------------------
      Jeff Jeff
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Please say in regular words what you want the formula to do and I will help you with the syntax.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------