Discussions

Expand all | Collapse all

how to calculate overdue workdays

  • 1.  how to calculate overdue workdays

    Posted 05-14-2018 21:05
    how to calculate overdue workdays?


    Currently, I use the formula below to get overdue days of my tasks. It works well. However, I'd like to make the overdue day is workday instead of calendar day. Got confused with date functions. Please help. Thanks a lot.  



    Overdue: Today() - ToDate([Projected Finish]))  (Also, get error: expecting text/daytime but find workdate, but still can save this formula)

    Project Finish: WeekdayAdd(ToWorkDate([Start]),[Duration])

    Duration: Case([Task Name], "Delegation",2, "Design",5)


  • 2.  RE: how to calculate overdue workdays

    Posted 05-15-2018 04:53
    try removing the "ToDate" before the [Project Finish]


  • 3.  RE: how to calculate overdue workdays

    Posted 05-17-2018 12:45
    Thank you Matthew.

    If you remove "ToDate" before the [Project Finish], it says "operator "-" can't apply to type date and workday. Still error. 

     


  • 4.  RE: how to calculate overdue workdays

    Posted 11-16-2018 18:01
    Try:
    WeekdaySub(Today(),[Projected Finish], ToDays(Today() - [Projected Finish])