• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help PLEASE...Schedule Delivery Date excluding Weekends

S

Sahadev Reddy

New Member
Hello,

Need your help in getting a formula for the below issue.

I need to provide the schedule end date based on the lead time.In the below table, The numbers under the column Number are fixed and numbers in the Schedule Delivery are based on the Lead time.In this case Lead time is 1 so the items shipped on Monday(referring 2) will deliver on Tuesday(so the number next to Monday in the Scheduled delivery is 3.For the items shipped on Friday will ship on Monday.I need a formula in the Scheduled delivery column which returns the value of the day(Number) on which delivery happens, this should exclude weekends if the delivery falls on weekends.Please do the needful.

Day Number Schedule Delivery Lead Time
Monday 2 3 1
Tuesday 3 4
Wednesday 4 5
Thursday 5 6
Friday 6 2

Regards,
Saha
 
Hi Saha,

You could add another column to give you the day of the week as well

=CHOOSE(WEEKDAY(WORKDAY(B2,D2)),,"Monday","Tuesday","Wednesday","Thursday","Friday")
 
Thank you Sir, I would like to add one more column next to the Schedule delivery column which is No.of days which should give me the number of days between the number and the Scheduled delivery which will give me the no.of days including weekend.

To be more precise we shall take the example of the one that ships on Friday and scheduled delivery is on Monday of the lead time is 1, no.of days should give the result as 3 which includes weekends.

Col A:Day--Friday
Col B:Number--6
Col C:Scheduled Delivery--2
Col D:No.of days--3
Col E:Lead Time--1

Regards,
Saha.
 
You must log in or register to reply here.
Back
Top