HI,
Im looking for a formula which can show how much stock will become out of date based on weekly usage.
There are multiply items all of which have different use by dates so if the stock expires or runs out it will know to consume the next use by date and so on.
Ive attached the a image so...