Hi i have a problem making a correct formula that returns an order in an inventory model at a specifik date.
The inventory model is build so that when the inventory comes below a predertimend point it wil issue an order of a fixed size for new products to refill the inventory. If the demand has made the inventory shrink by x numbers of fixed order sizes it will order x numbers of fixed orders until it is above the reorder point again. Every order that is ordered has a delivery time in days that are random. Now my problem it to make an excel formula that will return the number of orders for correct day. I have tried with a COUNTIF formula but this only count the number of succeses and doesnt return the number of orders that have been ordered.