Buttertoast
New Member
- Joined
- Feb 5, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello!
New here. I need some expert guidance about a spreadsheet I am working on and will be working on in the future. I have attached a copy of the spreadsheet. Basically, what I need is to determine an earlier date when I can accommodate delivery. There are several conditions and I hope anybody can help me design this spreadsheet more efficiently.
Column L must determine a date an earlier date where a delivery could be possible. The conditions are: This date must be on a day indicated on column L; Must belong on it's designated week based on column J. (E.G. Week 1 would be Feb. 3-7, Week 3 would be Feb 17-21..) And that the date must be earlier prior reset date (Column E).
If you can see on Row 4: M4 is the Friday where this customer could be delivered earlier than reset date (2/17/2020)
Hope anyone can help.
New here. I need some expert guidance about a spreadsheet I am working on and will be working on in the future. I have attached a copy of the spreadsheet. Basically, what I need is to determine an earlier date when I can accommodate delivery. There are several conditions and I hope anybody can help me design this spreadsheet more efficiently.
Column L must determine a date an earlier date where a delivery could be possible. The conditions are: This date must be on a day indicated on column L; Must belong on it's designated week based on column J. (E.G. Week 1 would be Feb. 3-7, Week 3 would be Feb 17-21..) And that the date must be earlier prior reset date (Column E).
If you can see on Row 4: M4 is the Friday where this customer could be delivered earlier than reset date (2/17/2020)
Hope anyone can help.