Hi gurus,
Been given a challenge to deliver 200 articles with a tolerance of +/- 1 month with following requirements:
- 200 Articles have same warranty dates
- Delivery Tolerance +- 1 month (Early September - Early November)
- Delivery Time must be only 10 am or 2 pm
- Delivery only 2 articles per day (10 articles per week)
- Date Format: 20/03/2018 10:00:00
Monday:
- 1 article @ 10 am
- 1 article @ 2pm
Tuesday:
- 1 article @ 10 am
- 1 article @ 2pm
Wednesday
- 1 article @ 10 am
- 1 article @ 2pm
Thursday
- 1 article @ 10 am
- 1 article @ 2pm
Friday
- 1 article @ 10 am
- 1 article @ 2pm
I have created a XL sheet with 2 manual scenarios with a delivery of 10 articles per week and 20 articles per week
Just wondering if someone could assist me on how to either get a formula or a VBA code.
Thank you.
Bookmarks