Results 1 to 4 of 4

I would like a formula to calculate how many days cover i have in stock

Threaded View

  1. 04-09-2018, 07:11 AM #1
    jimknight
    jimknight is offline
    Registered User
    Join Date
    04-09-2018
    Location
    Somerset, England
    MS-Off Ver
    2010
    Posts
    2

    I would like a formula to calculate how many days cover i have in stock

    Please can I have some help with a formula to calculate how many days cover that I have in stock

    I have attached a file to show the data - in the yellow square I would like to display how many days cover that I have in stock.

    Closing being the stock and the green numbers are the daily forecast.

    Many thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stock cover days
    By spl in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 08-24-2021, 08:25 AM
  2. Need help : formula to calculate stock cover in months
    By samike in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-09-2017, 05:24 PM
  3. Stock cover days with variable sales and delivery quantities
    By Marco_3 in forum Excel General
    Replies: 7
    Last Post: 08-21-2017, 01:54 PM
  4. How to set up formula on stock order by respective the stock cover day
    By leakhna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2016, 06:25 AM
  5. How to Calculate ( STOCK IN DAYS )
    By jaweedakbar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2012, 10:13 AM
  6. Formula to calculate months cover
    By MSABBIE in forum Excel General
    Replies: 7
    Last Post: 02-24-2009, 07:22 PM
  7. [SOLVED] HELP! Single cell formula to calculate weeks cover of stock on forward sales.
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2006, 06:25 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1