Hey all, got a bit of a complicated, and potentially unattainable, problem that I've been working with for awhile. I want it to do a specific thing, but I'm not sure it can be done.
I have a listing of colleges that my company is working with to print specific items for them. We are printing a brochure that is the same except for the name of the college on the front of the printed piece. Each college needs different quantities of the brochure at different times and so on.
There are about 200+ or so, going to be probably another 100 added to the list. The spreadsheet includes the college name, the state its located in, the quantity the college has ordered, specific ordering codes and finally the due date of the items.
I've created a full spreadsheet with all the colleges on there. However, my goal is to filter some of the data. I have a function in place that divides up the colleges by month, shown here:
=MONTH(A8)
The function basically calls upon the due date and shows the month in numerical form. So if its april, 4 would show up. This helps me to filter the due dates by month, but I want to try to do it by week. So if there were items due between 4/20 and 4/24 it would sort them by that week and no other orders would show up. This way I could print it out and give it to the foreman out in production.
I know there is a way to do it by the "sort" function, but I want to have a specific function that could label the row as a specific week so I could autofilter quickly. So if it was the 4/20 thru 4/24, it would be labeled as something like 4.3 because its in the month of april and its the 3rd complete week in april. Again, not sure if this is attainable, but wanted to ask anyway.
Attached is an example that I was working with. The month thing is in there as a baseline, any help would be awesome.
Bookmarks