Results 1 to 2 of 2

Thread: Calculate end of stock date with NPER formular
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculate end of stock date with NPER formular

    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

  2. #2
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculate end of stock date with NPER formular


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •