Assistance with Runout Dates?

[faviles5566]

Hi all,

Hoping to get some help on the below, and thanks in advance for your help!

I have the below information showing stock balance day by day. How can I come up with a formula that will automatically pull my out of stock/runout date? For example Item 8 is already OOS, Item 24 will OOS on 6/20, and Item 29 will OOS on 6/18. I've tried using a count if formula with current date however, the runout date was not accurate. Any input here?

Thanks!

Name	Part Description	6/17/2024	6/18/2024	6/19/2024	6/20/2024	6/21/2024	6/22/2024
Item 1	Item Description 1	16836	16716	16560	16440	16320	16200
Item 2	Item Description 2	18732	18536	18280	18028	17832	17636
Item 3	Item Description 3	67824	66228	62064	60684	59172	57708
Item 4	Item Description 4	54960	52836	36636	34140	32148	29928
Item 5	Item Description 5	132	132	132	132	132	132
Item 6	Item Description 6	26898	26898	26898	26298	26298	26220
Item 7	Item Description 7	1662	1662	1662	1662	1662	1662
Item 8	Item Description 8	0	0	0	0	0	0
Item 9	Item Description 9	1566	84	84	84	84	84
Item 10	Item Description 10	164856	156216	136152	132960	130152	127800
Item 11	Item Description 11	14400	14340	14292	14232	14184	14124
Item 12	Item Description 12	6846	6486	6126	5772	5412	5052
Item 13	Item Description 13	14562	14232	13902	13578	13248	12918
Item 14	Item Description 14	120888	274296	242088	67200	70656	96072
Item 15	Item Description 15	9120	9108	9072	9036	9000	8964
Item 16	Item Description 16	114202	86602	107194	237430	220627	218323
Item 17	Item Description 17	143526	98238	127668	144222	106223	105281
Item 18	Item Description 18	35982	35970	21696	21678	35916	35904
Item 19	Item Description 19	18678	18090	17502	16920	16332	15744
Item 20	Item Description 20	211812	208368	208632	204840	203340	201816
Item 21	Item Description 21	10416	10356	10284	10176	10104	10056
Item 22	Item Description 22	40500	40416	11556	11472	56208	56184
Item 23	Item Description 23	996	996	996	996	996	996
Item 24	Item Description 24	12	12	12	0	0	0
Item 25	Item Description 25	20368	18976	17728	15104	13888	8928
Item 26	Item Description 26	33840	19664	33616	33536	26304	26208
Item 27	Item Description 27	42144	41776	40928	40016	39424	38768
Item 28	Item Description 28	52464	49776	37376	34624	46960	45104
Item 29	Item Description 29	1176	-72	-1752	-2364	45018	44400

 

[Fluff]

Hi & welcome to MrExcel.
For 365 how about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Name	Part Description	17/06/2024	18/06/2024	19/06/2024	20/06/2024	21/06/2024	22/06/2024
2	Item 1	Item Description 1	16836	16716	16560	16440	16320	16200
3	Item 2	Item Description 2	18732	18536	18280	18028	17832	17636
4	Item 3	Item Description 3	67824	66228	62064	60684	59172	57708
5	Item 4	Item Description 4	54960	52836	36636	34140	32148	29928
6	Item 5	Item Description 5	132	132	132	132	132	132
7	Item 6	Item Description 6	26898	26898	26898	26298	26298	26220
8	Item 7	Item Description 7	1662	1662	1662	1662	1662	1662
9	Item 8	Item Description 8	0	0	0	0	0	0	17/06/2024
10	Item 9	Item Description 9	1566	84	84	84	84	84
11	Item 10	Item Description 10	164856	156216	136152	132960	130152	127800
12	Item 11	Item Description 11	14400	14340	14292	14232	14184	14124
13	Item 12	Item Description 12	6846	6486	6126	5772	5412	5052
14	Item 13	Item Description 13	14562	14232	13902	13578	13248	12918
15	Item 14	Item Description 14	120888	274296	242088	67200	70656	96072
16	Item 15	Item Description 15	9120	9108	9072	9036	9000	8964
17	Item 16	Item Description 16	114202	86602	107194	237430	220627	218323
18	Item 17	Item Description 17	143526	98238	127668	144222	106223	105281
19	Item 18	Item Description 18	35982	35970	21696	21678	35916	35904
20	Item 19	Item Description 19	18678	18090	17502	16920	16332	15744
21	Item 20	Item Description 20	211812	208368	208632	204840	203340	201816
22	Item 21	Item Description 21	10416	10356	10284	10176	10104	10056
23	Item 22	Item Description 22	40500	40416	11556	11472	56208	56184
24	Item 23	Item Description 23	996	996	996	996	996	996
25	Item 24	Item Description 24	12	12	12	0	0	0	20/06/2024
26	Item 25	Item Description 25	20368	18976	17728	15104	13888	8928
27	Item 26	Item Description 26	33840	19664	33616	33536	26304	26208
28	Item 27	Item Description 27	42144	41776	40928	40016	39424	38768
29	Item 28	Item Description 28	52464	49776	37376	34624	46960	45104
30	Item 29	Item Description 29	1176	-72	-1752	-2364	45018	44400	18/06/2024
Data

Cell Formulas
Range	Formula
I2:I30	I2	=LET(m,MINIFS($C$1:$H$1,C2:H2,"<=0"),IF(m=0,"",m))