Discussions

Expand all | Collapse all

Duration for Workdays

  • 1.  Duration for Workdays

    Posted 13 days ago
    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
    ------------------------------


  • 2.  RE: Duration for Workdays

    Posted 13 days 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
    ------------------------------



  • 3.  RE: Duration for Workdays

    Posted 13 days 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
    ------------------------------



  • 4.  RE: Duration for Workdays

    Posted 13 days 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
    ------------------------------



  • 5.  RE: Duration for Workdays

    Posted 13 days 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
    ------------------------------



  • 6.  RE: Duration for Workdays

    Posted 13 days 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
    ------------------------------