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 |
Democat Wrote: 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. Hi Democat, I think so... Can you attach an example cause i cant get it quite clear. regards, sam -- sanskar_d ------------------------------------------------------------------------ sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217 View this thread: http://www.excelforum.com/showthread...hreadid=379602 |
Hi!
Would not a simple IF function work? For your data, try =IF(AND(($A2<C$1+3),($A2C$1-3)),$B2,0) in each cell in columns C thru X, for all rows having data. This will work best if you have few lines of data. Rajni "Democat" wrote in message ... 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 |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com