Stock & sales calculation

[Sigh]

I cells B1-M1 I have the months of the year, In A2 I have the current stock figure, in B2-M2 are the sales figures for each month in the previous year. In N2 I would like a calculation that subtracts the sales from the stock figure and reports the month in which there will be no stock left, is this possible in a formula?

 

[Dave Patton]

Array enter

=LOOKUP(MIN(IF(SUBTOTAL(9,OFFSET($B4,0,0,1,COLUMN($B4:$M4)-COLUMN(B4)+1))>=$A$2, COLUMN($B4:$M4)-COLUMN(B4)+1)),P3:Q14)

 

[Sigh]

Just what I was looking for, thanks Dave!

 

[Dave Patton]

Thanks for the feedback. Dave