Duration formula that only counts business days

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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?
 
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
The function WeekdaySub([(Finish Date], [Start Date])

will return a numeric value if the number of weekdays not counting weekends, between two dates.
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
IF (not [Assigned], WeekDaySub(Today(), ToDate([Date Created]))
Photo of Adam Tanner

Adam Tanner

  • 206 Points 100 badge 2x thumb
You are the man! Thank you so much!
Photo of Leslie Meyer

Leslie Meyer

  • 120 Points 100 badge 2x thumb
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]))
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 48,444 Points 20k badge 2x thumb
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?
Photo of Leslie Meyer

Leslie Meyer

  • 120 Points 100 badge 2x thumb
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.