AnsweredAssumed Answered

How to calculate elasped business days

Question asked by rrs9999 on Feb 15, 2010


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.