# Duration formula that only counts business days

• 0
• Question
• Updated 11 months ago
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?

• 206 Points

Posted 2 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,268 Points
The function WeekdaySub([(Finish Date], [Start Date])

will return a numeric value if the number of weekdays not counting weekends, between two dates.
• 206 Points
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?

QuickBaseCoach App Dev./Training, Champion

• 67,268 Points
IF (not [Assigned], WeekDaySub(Today(), ToDate([Date Created]))
• 206 Points
You are the man! Thank you so much!
• 130 Points
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]))

QuickBaseCoach App Dev./Training, Champion

• 67,268 Points
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?
• 130 Points
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.