Creating and populating a calendar based on a table of data with dates and finances.

I have built a data table with my monthly expenses;

Colum "A" items: mortgage, phone, gas, groceries, insurance, property taxes, etc.;
Colum "B" Payment amount of corresponding item from Colum "A";
Colum "C" frequency of payment in days (example: mortgage every 15 days, phone bill every 30 days);
Colum "D" Last payment date;
Colum "E - Z" Subsequent payment date based on last payment made and the frequency of payment.

My question: is there a way to build a calendar that can reference the table and then the calendar would be populated with a list of payments on each relevant date?

Thank you in advance,

Greg

Welcome to the forum.

Take a look at this thread:

https://www.excelforum.com/excel-gen...ing-dates.html

It is about repeating dates of events (3, 4 or 6 month intervals) and displaying the data in calendar format, so you might be able to find some common ground with your own requirements.

It would help in future if you were to attach a sample Excel workbook, showing what you have and what you would like to do with it - the yellow banner at the top of the screen describes how you can do this.

Hope this helps.

Pete