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

    How to calculate elasped business days



      How to calculate elasped business days


      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.