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 have any tips on how to do this?
 
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    The function WeekdaySub([(Finish Date], [Start Date])

    will return a numeric value if the number of weekdays not counting weekends, between two dates.
  • AdamTanner's avatar
    AdamTanner
    Qrew Trainee
    8 years ago
    I would only like this to calculate if [assigned]=false

    weekdaysub(now(), [date created], if([assigned]=null))

    Could you help me with this formula please?
  • 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.