Calculate end of stock date with NPER formular

[Kakion78]

[FONT=&quot]Hi all,[/FONT]

[FONT=&quot]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=&quot]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=&quot]I hope you can help [/FONT]

[FONT=&quot]BR Kasper[/FONT]

 

[Kakion78]

Link to excel file

https://wetransfer.com/downloads/a1...e4bcb4b93772ad90fc6cd74220190910095553/cf710a