LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I fix a forecast date that has passed for a zero value? chicken Excel Discussion (Misc queries) 0 November 29th 06 06:05 AM
Forecast function and Date option trickout Excel Worksheet Functions 0 November 17th 06 05:10 PM
Forecast using 2 data sets goofy11 Excel Worksheet Functions 1 October 24th 06 07:04 PM
Changing Forecast Data to Actual Brian Hearty via OfficeKB.com Excel Discussion (Misc queries) 3 January 12th 06 08:21 AM
Moving data in financial forecast ashleyfox Excel Worksheet Functions 1 September 5th 05 04:39 AM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"