Projecting $ Transactions
Posted by Dwight on August 24, 2001 5:16 AM
A6:A25 are for entry of one of three transaction types: Loan, DDA, or Fee. B6:B25 are for entry of a corresponding date when the transaction is anticipated to occur. C6:C26 are for entry of the dollar amount of the transaction. I would like formulas in the range B2:D4 which show total dollar amounts for each category which are projected to occur in the next 30, 60, and 90 days respectively. For instance, B2 would be loans within 30 days, C2 loans within 60 days, D2 Loans within 90 days, B3 would be DDA within 30 days, and so on. In this example, if row 6 indicated a $500,000 loan projected to close on 10/1/01, then as of today that $500,000 would be part of a total displayed in C2 (Loans within 60 days).
Any help would be appreciated, and I would be glad to e-mail the example to anyone who might help complete.