AnsweredAssumed Answered

How to calculate elasped business days

Question asked by rrs9999 on Feb 15, 2010

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.

Outcomes