Forum Discussion

RebekahAlcantar's avatar
RebekahAlcantar
Qrew Trainee
8 years ago

I need help to create a formula to calculate a complex duration issue.

I need help to create a formula to calculate a complex duration issue. I am tracking aging of support tickets from two different systems. Therefore, I have a total of 4 time stamps.  I need an over...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
  • If Target resolution date and Actual Resolution Date is blank, calculate the number of business days between Date Identified and today's date

  • If Actual Resolution Date is blank, calculate the number of business days between Date Identified and today's date

    If Actual Resolution Date is not blank, calculate the number of business days between Date Identified and Actual Resolution Date



Try this:

IF(
isnull([Target resolution date]) and isnull([Actual Resolution Date]), weekdaysub(Today(), [Date Identified]),

isnull([Actual Resolution Date]), weekdaysub(today(), [date Identified]),

not isnull([actual resolution date]), weekdaysub([actual resolution date],[date identified]))