Hello All,
Can anyone provide me the formula to give me the number of calendar days to a specific number of manufacturing days? For example, the supplier tells me it will be 4 manufacturing weeks lead time. I need to know how many calendar days it will be. I'm thinking it should be something simple, but I am brain dead for some reason.
thanks in advance!
Does the manufacturer work 5 or 7 days a week?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
The manufacturing days would be 5 days.
Take a look at =NETWORKDAYS(start_date,end_date,holidays)
HTH
Regards, Jeff
Hi,
Try using Networkdays formula to calculate working days between two dates
Well, for Networkdays, I would need the End Date, and that's what I'm trying to find out.
So you'd use WORKDAY function.
Ex. You have Start Date in Column A, Manufacturing Week in B, Calculation in Column C
EndDate.JPG
If the manufacturer has custom weekend (ex. works Tue-Sat) use WORKDAY.INTL
Also consider building holiday table.
Thank you so much CK76! It helped me in that all I had to do was add one more formula, to get the total number of days, which was my original goal. I added DAYS360 to count the number of manufacturing days.
Thank you so much for your help!
mfgr days.jpg
I'm coming back into this pretty late, but I have a question. If the manufacturing is on a 5 day work week, wouldn't the total manufacturing days be 21 instead of 28 in your example?
Nah, OP is using Workday to find the end date. Then he's getting calendar days by subtracting start date from end date.
Dang.....I gotcha. Not sure how I missed that in the original post.
Do you really need WORKDAY and DAYS360 for this? If a job will take 4 weeks isn't that just 7*4 = 28?Originally Posted by marcella needs help
Can anyone provide me the formula to give me the number of calendar days to a specific number of manufacturing days? For example, the supplier tells me it will be 4 manufacturing weeks lead time. I need to know how many calendar days it will be. I'm thinking it should be something simple, but I am brain dead for some reason.
Audere est facere
Not really, if one doesn't need to consider stat holiday etc. If holidays need to be taken into account, you need WORKDAY.Do you really need WORKDAY and DAYS360 for this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks