Forumula to Determine Payables

[robert_shindorf]

Hey guys, I'm having an issue trying to figure out a formula to use for this...

I want to enter the number of days that you pay your average payables into a cell.
Then, in 12 cells across it has the average amount of payables per month.
I then need to have a way to display the cash paid out for payables on a monthly basis.... this will be used for cash flow projections, to show average cash balances available.

Anyone have a solution for this... it will be used to illustrate the cash flow, and how adjusting timing can increase or decrease required cash.

[sglife]

How about you try first by using the basic math functions, like average, sum
Then give us the sample for your problem that can not be solved