Forum Discussion

AdamTanner's avatar
AdamTanner
Qrew Trainee
8 years ago

Duration formula that only counts business days

I am trying to come up with a formula to track an SLA and only count business days. Right now my formula looks like this : (ToDays([Date Created]-(If([Assigned]=false,Now())))*-1) Does anyone...
Formulas and functions
LeslieMeyer's avatar
LeslieMeyer
Qrew Member
7 years ago
Can you provide me with a variation on the formula above?  I need the max of the last two dates, and this formula attempt isn't right:  WeekdaySub([Date Completed], (max[Assigned Date],[Re-assignment Date]))
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Can you post the error message or describe the problem with the result of your formula?

    Are all the field involved date field types or are some of them a different field type such as date/time of text?
  • LeslieMeyer's avatar
    LeslieMeyer
    Qrew Member
    7 years ago
    thank you for the quick reply. It turns out I had the wrong field type in my formula field.  it should have been a formula-duration and not a formula-number.