# Discussions

View Only

## Duration formula that only counts business days

• #### 1.  Duration formula that only counts business days

Posted 08-08-2017 17:52
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?

• #### 2.  RE: Duration formula that only counts business days

Posted 08-08-2017 19:55
The function WeekdaySub([(Finish Date], [Start Date])

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

• #### 3.  RE: Duration formula that only counts business days

Posted 08-08-2017 20:00
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?

• #### 4.  RE: Duration formula that only counts business days

Posted 08-08-2017 20:11
IF (not [Assigned], WeekDaySub(Today(), ToDate([Date Created]))

• #### 5.  RE: Duration formula that only counts business days

Posted 08-08-2017 20:16
You are the man! Thank you so much!

• #### 6.  RE: Duration formula that only counts business days

Posted 06-14-2018 20:36
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]))

• #### 7.  RE: Duration formula that only counts business days

Posted 06-14-2018 22:36
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?

• #### 8.  RE: Duration formula that only counts business days

Posted 06-15-2018 12:55
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.