3 Replies Latest reply on Jul 17, 2018 9:39 AM by Pearl.pat.0

    Number of weekend days between two dates (or business days)

    Jason Scarlett

      After much searching and seeing various solutions, I think this solution may be the simplest.

      The basic idea is to:

      1. Calculate the number of weeks that overlap a Saturday
        (number of days + bonus week)/7
      2. Double this count
      3. Add lone Sunday
      4. Subtract lone Sunday

       

      Getting "business days" from this is straight forward .. next up holidays