forcasting an out of stock date

[scottfshr]

I have an excel sheet where I forecast an out of stock date. {=MIN(IF(Sheet1!K4:K368>0,Sheet1!K4:K368))}. formula stopped working properly and is looking at the number closest to zero which Is a past date. I Only need the formula to look at todays date forward

 

[Panda514]

This thread has the same question. Good luck!

https://www.excelforum.com/excel-general/746359-need-to-find-lowest-date-after-todays-date.html

 

[AhoyNC]

Try adding the Date column to your formula. See example below, change ranges to match your data.
This is an array formula and must be entered with CTRL-SHIFt-ENTER.

Excel Workbook
	J	K	L	M
3	Date	Stock		3
4	3/1/2019	2
5	3/1/2019	0
6	3/8/2019	1
7	3/16/2019	5
8	3/17/2019	3
9	3/18/2019	6
Sheet

 

[scottfshr]

I am getting the 1/0/1900 error in the cell. I have doubled checks the date cell range (all formatted in date ) and the range of cells are formatted in number. I did not type the Array but entered ctrl-shift-enter at the end o the formula a the {} brackets did show up Formula shows a an array as {=min(if)a3:a367>=today(),if(m3:m367>0,m3:m367)))}. column A is the date rage, column M is the projected balance of inventory. I want the cell to look at todays date and forward and give me the date that is projected to be out of stock or what ever value I enter > and give me that date.

 

[AhoyNC]

Check to make sure your dates are numeric. Just because a cell is formatted as date doesn't mean it is an actual Excel date (could be text).
Use the ISNUMBER function. It should return TRUE.
In the example below both cells A1 & A2 are formatted as date, but A2 was entered as text.

Excel Workbook
	A	B
1	4/3/2019	TRUE
2	4/3/2019	FALSE
Sheet