Skip to main content
Question

how to calculate overdue workdays

  • May 15, 2018
  • 0 replies
  • 122 views
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)
This topic has been closed for replies.

  • MCFNeil
  • Quickbase Alumni
  • May 15, 2018
try removing the "ToDate" before the [Project Finish]
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • May 17, 2018
Thank you Matthew.

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

 
Forum|alt.badge.img+1
  • AudraMickles
  • Quickbase Alumni
  • November 16, 2018
Try:
WeekdaySub(Today(),[Projected Finish], ToDays(Today() - [Projected Finish])
Terms & ConditionsAccessibility statement