Formula for writing a forecast of my expenses

Hi All,

I am currently trying to write a formula for my expenses, but what i want to do is to write it by day for the full year.

I have some expenses like Mortgage which goes out every month, but others like water which only goes out every quarter.

How do I go about writing a formula for the frequency of the expense as well as the amount, especially if the expenses occurs on the 31 of the month, or after 28th (for Feb), and so in the months of Feb I would want it to fall on the end of the month.

Kind Regards

Ali