Recurring Monthly Expenses

I have created an monthly budget spreadsheet on excel with a calendar. Can anyone help me with figuring out the formula to show the recurring expenses in the calendar? (Example: Rent/Mortgage on the 1st of every month)

This is what I have.

Hi zn_pipkns

Welcome to the forum.

You will need two additional bits of information: 1 The date the payment is due; 2 Which of the payments are regular.

Having decided these, I would go to the month to which you want to add these transactions and then run a macro that will pick up these regular payments. If you re-design the budget screen to accommodate the additional information, I could write a macro (as could a number of contributors! ). A formula based option would be beyond me - especially if there happened to be two or more payments due on the same day if the month.

You will also need to decide the rules for payments that fall due on 29th, 30th or 31st of a month - what happens in February?

Regards
Alastair