0 Replies Latest reply on Feb 15, 2010 11:29 AM by rrs9999

    How to calculate elasped business days

    rrs9999

      Title

      How to calculate elasped business days

      Post

      I am trying to calculate a due date based on number business days.  So I want to skip the weekend days but not report on the following Monday, but with the total number of work days projected.

       

      I have tried other formulas here, but the most applicable is not working past the next Monday after a weekend.

       

       

      This is my current attempt:

      access date + response calc + Middle ("1000002"; Mod (access date + response calc - Date (1;3;1904);7) +1;1)

       

      access date is a date field

      response calc is calc field, number result

       

      Any input appreciated.