Duration formula that only counts business days

  • 0
  • 1
  • Question
  • Updated 1 year 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 2 years ago

  • 0
  • 1
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?
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

  • 130 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]))
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

  • 130 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.