i am creating a monthly cashflow model from income statement. The problem is timing of the cash receipts & payments is not certain. sometime i receive 3 months advance from customers whereas sometime i get after 2 months etc. similarly with cash outflows sometimes i pay 2 months in advance of the recipt of goods. SOmetime i get 4 months credit.

I wanna create a sheet where i just change the number of months i am getting credit & number of months i am giving credits to customers and the whole spreadsheet automatically get updated.

PLease suggest what is the best way to do it.

e.g. If i get 2 months advance from customers. i select 2 months in column A and my cashflows sheet automatcilly take the next two months sales