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
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
While we are waiting for you to attach your file, so we can give you a solution specific to your situation, here is how those two functions work.
WORKDAY (not WORKDAYS) will take a start date, and number of working days, and tell you the end date. It counts Monday-Friday as working days.
WORKDAY(startdate, days [, holidays])
You may optionally add a range that contains a list of holiday dates.
WORKDAY.INTL is available to specify working days other than Mon-Fri.
NETWORKDAYS will take a start date and end date, and tell you how many working days there are between those two dates. (The way to read the name of this function is Net Workdays, not Network Days.)
NETWORKDAYS(startdate, enddate [, holidays])
Calculating the date is easy. You will use WORKDAY. The start date will be TODAY(). However, there is not enough information in your post to figure out how many working days remain for all jobs. So we will wait for your file to see how you are doing this.I need to calculate, from today, the date that all jobs will be complete.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks