I'm trying to calculate runout dates based on requirements and inventory. I started with a running total of the requirements. You can see in the screenshot that for the March 24th line, I want to select the date when my requirements will use up my TotInventory, which is 06/30/2025. I've created logic for that, but now I want to be able to do it for every line. So for the 03/31/2025 line, I want to determine when 53 will run out, which is 06/30/2025. I think I'm overthinking this. Is there a way to do a formula to look down the running total and return the relevant date? Or do I need to cross tab it somehow? Note that I'm going to roll this up to hundreds of thousand product location combinations. Thoughts? Uploading the sample data.
