Hi

I am working on a personal cash flow .xls and would like to be able to auto populate the monthly bills that are due that week.
Not sure where to start withthis as there are (I am sure) several ways to go about it.

For example: I get paid weekly so cash flow is managed weekly. Bills are monthly and I do not want to prorata them, I would like to know from their due dates which week they need to be paid.

Week Starting 31/12/2012 Balance £100.00
Savings In Out Balance
Income £500.00 £600.00
Phone £35.00 £565.00
Gym £11.00 £554.00

Phone is due 3rd of each month
Gym is due 17th of each month

Any guidence on how to make this work greatly appreciated.