• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate end of stock date with NPER formular

Kasper Devald

New Member
Hi all,

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.

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?

I hope you can help ;-)

BR Kasper