I have a stock volume in column A. I then have a forecasted sales volume by week for 10 weeks in the nest 10 columns. I need to include a formula which tells me how long the stock in column A will last in weeks. This needs to be dynamic and adjust if I adjust up or down the sales forecasts in a given week. I cant use an average as certain weeks will have heavy spikes or dips.Essentially a weeks of stock calculator.
Solved by C. A. in 30 mins