Dear Members,

First I'm a new user on this forum, and I would like to say Hello to everyone.
Second I have a few questions regarding my attached excel table.

I work in a firm that produces car parts, and I reqularly recieve forecasts from our partners, which shows us how many parts they want on each daily shipments we send them, these forecasts are broken down to days and usually consist of 3 months.

My question is what formula I should use if I want to put our actual stock in for example B7, B8, B9, B10, and I would like to see for what date its fully enough according to the forecast, and If its not enough for a date it shouldn't even mention that date. If its for example 340 parts left and the last date requires 400 it should say the prvious date. I would like to see the dates (that our stock is enough for) in C7,C8,C9,C10. Thanks in advance.