Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

how to calculate overdue workdays

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)
Formulas and functions
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    7 years ago
    try removing the "ToDate" before the [Project Finish]
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    Thank you Matthew.

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

     
  • AudraMickles's avatar
    AudraMickles
    Qrew Trainee
    7 years ago
    Try:
    WeekdaySub(Today(),[Projected Finish], ToDays(Today() - [Projected Finish])