Discussions

Expand all | Collapse all

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.