how to calculate overdue workdays

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
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)
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
try removing the "ToDate" before the [Project Finish]
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Thank you Matthew.

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