Hello all,
At this point I am just nitpicking at my chart, but I think my brain has had just about enough.
What I am trying to do is automate the overlap column of this table. The table has multiple rows of the same Item Number, but different Lot numbers that will be consumed at different days, and different rates. For maximum efficiency there must be some overlap, and that overlap will in turn increase the duration of how long the item will last. Further, since the weekends are already excluded from the duration by way of the WORKDAY function, the overlap should not count weekends when calculating overlapping days.
I began a formula (see W2) that I thought would do what I needed, but my brain has fizzled out on trying to reference the correct cells of the appropriate start and end dates (I'm not very good at index matching, regardless).
Anyways, take a look, and if you think you see a solution, please let me know.
Thanks!
Bookmarks