Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula help to calculate inventory days (2002 SP3)

    At work yesterday, someone asked if this Excel formula was possible. I have not been able to figure out how to do this one. It may not even be possible. In the attached file cell, C9 should calculate how many days they are behind or a head of a schedule for that model number. The answer is -5.5 days behind. The days marked with a zero do not count as a schedule day.

    Any help or suggestions would be appreciated

    Thank You,
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula help to calculate inventory days (2002 SP3)

    Could you explain the worksheet? I don't have the slightest idea what it means.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula help to calculate inventory days (2002 SP3)

    We need a little more info:
    If C9 is supposed to be -5.5 what is the logic for arriving at that conclusion?

    Is the calcluation in C9 incorrect? or are the values in C8 and/or C5 incorrect?

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula help to calculate inventory days (2002 SP3)

    Sorry, for not being too clear. The person who asked for help keeps standing over my shoulder saying are you done yet every 10 minutes. I was rather rushed, let me ask him his logic on what this sheet is to accomplish. As I do not understand what he is, telling me what he needs fully myself.

Posting Permissions

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