Skip to main content
Question

Duration formula that only counts business days

  • August 8, 2017
  • 0 replies
  • 352 views
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?
 
    This topic has been closed for replies.

    The function WeekdaySub([(Finish Date], [Start Date])

    will return a numeric value if the number of weekdays not counting weekends, between two dates.
    • AdamTanner
    • Author
    • Quickbase Alumni
    • August 9, 2017
    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]))
    • AdamTanner
    • Author
    • Quickbase Alumni
    • August 9, 2017
    You are the man! Thank you so much!
    • LeslieMeyer
    • Quickbase Alumni
    • June 15, 2018
    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]))
    Terms & ConditionsAccessibility statement