[FONT="]Hi all,[/FONT]
[FONT="]I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per day for each product.[/FONT]
[FONT="]I have attached a small sample of the calculation i use. My question is if it's possible to incorporate all the "End of stock" calculations I have marked in one formula?[/FONT]
[FONT="]I hope you can help [/FONT]
[FONT="]BR Kasper[/FONT]
[FONT="]I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per day for each product.[/FONT]
[FONT="]I have attached a small sample of the calculation i use. My question is if it's possible to incorporate all the "End of stock" calculations I have marked in one formula?[/FONT]
[FONT="]I hope you can help [/FONT]
[FONT="]BR Kasper[/FONT]