Results 1 to 7 of 7

Caculate number of weeks stock

Threaded View

  1. 03-12-2014, 05:14 PM #1
    dreamer1963
    dreamer1963 is offline
    Registered User
    Join Date
    03-11-2014
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    4

    Caculate number of weeks stock

    Hi

    Trying to think of a formula that will tell me the number weeks stock I have,would like to put the formula in h6 and copy across giving me the weeks stock

    Green line is sales, yellow balance stock


    EX1.JPG

    Any help would be good, need job and its driving me insane!
    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. [SOLVED] Dynamic chart to represent % of 52-weeks high and low of a stock
    By NikunjThakkar in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-09-2020, 05:45 AM
  2. How to caculate the number of cells within the same day?
    By williamkai1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2013, 07:21 AM
  3. Count the number of consecutive weeks that an item was out of stock in 1 year
    By tftjr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2013, 01:57 PM
  4. [SOLVED] NEW Returning 'Number' of 'Days' or 'Weeks' or 'Months' with # and text / number of employ
    By PERE in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2013, 02:50 AM
  5. HELP! Single cell formula to calculate weeks cover of stock on forward sales.
    By matthew.webb@net1.demon.co.uk 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