Good day!
I would like to ask for help and guidance about a complicated spreadsheet. I just accepted a new position in a retail company and one of the tasks is to determine a date prior to what they call a "Reset Date" There are so many conditions and since this is going to be one of my recurring task, I would really appreciate if anybody can help me out to make it a little easy than doing it manually. So here it goes!
Basically, what I need is to get the prior date that matches the conditions. Column M is where the results should be. On the attached file, you can see example on Row 4. Reset Date (Column E) is when the delivery should be, Week 1&3 and 2&4 means the week of the month (Week 1 would be Feb 3-7, Week 2 is Feb 10-14 etc..) It has alternating schedule. I need to get the date that matches the day in column L prior the reset date. On row 4, the early delivery would be 2/7/20 because this is the nearest possible date we can deliver according to the week (Column J) and day (Column L). I know it is very complicated and I am willing to change formats if I have to. I need help, please!
Thank you! Hoping to hear from you soon!
Bookmarks