Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forecast a date from data given
Hello, any help with this would be more than appreciated.
I need my spreadsheet to give me a date when I will run out of parts. A2: todays date C4 - J4 has my weekly requirements L4- has my parts on hand I need to find out based on my weekly requirements when I will be out of parts. Looks something like this. A2 (today date) c4 d4 e4 f4 g4 h4 i4 j 4 L4 m4 wk1 wk2 wk3 wk4 wk5 wk6 wk7 wk8 20 20 20 20 20 20 20 20 73 (Need parts date) Any help with a formula to calculate this would, again, be more than appreciated. I've been racking my brain for a week on this one. Thanks, James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
Forecast function and Date option | Excel Worksheet Functions | |||
Forecast using 2 data sets | Excel Worksheet Functions | |||
Changing Forecast Data to Actual | Excel Discussion (Misc queries) | |||
Moving data in financial forecast | Excel Worksheet Functions |