Hello,

I have a production problem I have not been able to figure out.

I have x number of jobs that are past due.

I have y number of jobs that are due today and going forward.

I can make z number of jobs per day.

I need to calculate, from today, the date that all jobs will be complete.

Work schedule is 1 shift, either 5 or 6 days per week.

I have a list of holidays.

I can't make sense of the WORKDAYS or NETWORKDAYS functions.

I appreciate any assistance you can offer.

Thank you,

Randy