I have to calculate an issue end date based on a table showing a select number of topics which have a specific number of days allotted for issue resolution. Table Example:
Executive Request 15
Internal Request 7
External Request 7
I'm trying to use the table above to calculate a project due date. (The date the issue was received plus the completion requirement in business days would = the project due date) I used this formula to calculate the due date: Expr1: [T-Inquiry_Source]!CompletionRequirement+NAVIssues!Date_Rcvd]which
returns: InquirySource CompletionRequirement Date_Rcvd Due Date
DCPSC 7 5/19/2006 5/26/2006
This works, but I was asked to make the "7" reflect only week days. Is there an easy way to calculate?