Hello,
I would like to ask you to help me with a formula.
Goal: how to calculate how many calendar days are left till next delivery day? The formula needs to calculate the number of calendar days till delivery even when delivery days would change (column C on the picture)
Info: Our supplier delivers only on Tuesdays and Thursdays. (column B on the picture). In the picture you will see that: 0 = no delivery. 1 = delivery.
Remarks:
- If we order on Monday, the delivery doesn't take place on Tuesday. The next possible delivery date is Thursday.
- If we order on Tuesday, the delivery doesn't take place on Tuesday. The next possible delivery date is Thursday.
- If we order on Wednesday, the delivery doesn't take place on Thursday. The next possible delivery date is Tuesday next week.
- If we order on Thursday, the delivery doesn't take place on Thursday. The next possible delivery date is Tuesday next week.
- The calculations starts on the next day after order and counts till the day and includes the day of the order. For example: Ordered on Monday and next delivery day is Thursday, then: Monday = 0 days, Tuesday = 1 day, Wednesday = 1 day, Thursday = 1 day. Total days till next delivery = 3.
I would like to ask you to help me with a formula.
Goal: how to calculate how many calendar days are left till next delivery day? The formula needs to calculate the number of calendar days till delivery even when delivery days would change (column C on the picture)
Info: Our supplier delivers only on Tuesdays and Thursdays. (column B on the picture). In the picture you will see that: 0 = no delivery. 1 = delivery.
Remarks:
- If we order on Monday, the delivery doesn't take place on Tuesday. The next possible delivery date is Thursday.
- If we order on Tuesday, the delivery doesn't take place on Tuesday. The next possible delivery date is Thursday.
- If we order on Wednesday, the delivery doesn't take place on Thursday. The next possible delivery date is Tuesday next week.
- If we order on Thursday, the delivery doesn't take place on Thursday. The next possible delivery date is Tuesday next week.
- The calculations starts on the next day after order and counts till the day and includes the day of the order. For example: Ordered on Monday and next delivery day is Thursday, then: Monday = 0 days, Tuesday = 1 day, Wednesday = 1 day, Thursday = 1 day. Total days till next delivery = 3.