Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Days until exhuast
Just as an example, let's say I'm a rental company that rents tools
for long periods of time. I want to understand how many tools are being rented, how many I have left in inventory still available to rent, and when I am going to exhaust my inventory. So for instance, I have the following three primary fields: 1. Number of tools out for rent. 2. Number of tools in inventory still available for rent. 3. Sales growth month over month. So using the sales growth, I should be able to roughly predict when I am going to run out of inventory (assuming my sales growth is going to continue to rise.) I can't wrap my head around the logic to be honest. The variable I want is the number of days left until I am going to run out of tools for run. Any Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) |