Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with forecasts/dates
I would like to look at a date within a cell and if the date is within a
certain range post an amount from another cell into the appropriate column. For example: my columns are as follows: Vendor name, due date, amount, week ending 9/7, 9/14, 9/21 etc. I want the formula to look at the due date and determine which week ending date the amount should be in for forecasting purposes. Does this make sense? How do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculating Monthly Production Forecasts | Excel Discussion (Misc queries) | |||
Comment: Better Sales Forecasts with Excel - from MS-Office librar | Excel Discussion (Misc queries) | |||
Need help creating forecasts informed by previous performance | Excel Discussion (Misc queries) | |||
Comparing scenarios/forecasts in Excel | Excel Worksheet Functions | |||
Updating Excel forecasts into an Access Database | Excel Worksheet Functions |