Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Duration for Workdays

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

2 Replies

Sort By
  • JeffBrown1's avatar
    JeffBrown1
    Qrew Trainee
    5 years ago
    I need it to have a running tally of days overdue based upon the due date in workdays until the job is complete.

    ------------------------------
    Jeff Jeff
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Not tested by try this

      IF([Status]<>"Completed" and Today() >[Task Due Date], WeekdaySub(Today(),[Task Due Date]))


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