Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cash Flow by Week
I have [column-a] dates and [column-b] corresponding amounts. Column-c thru -x are weekly periods represented by the Wednesday date of each week in [row1]. Can I use the LOOKUP function to find the week [date +- 3days] and place the amount in the proper column? Will an alternative function work better. Please help. I imagine scheduling amounts by period is a common useage. -- Democat ------------------------------------------------------------------------ Democat's Profile: http://www.excelforum.com/member.php...o&userid=24362 View this thread: http://www.excelforum.com/showthread...hreadid=379602 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
Cash Flow Distribution/IRR Modeling | Excel Discussion (Misc queries) | |||
projected cash flow and actual on same sheet | Excel Discussion (Misc queries) | |||
How do i create an automatic monthly cash flow from lists of cost. | Excel Discussion (Misc queries) | |||
Cash Flow Analysis | Excel Discussion (Misc queries) |