Create a interest payout calendar which can sorted by date/month

Hi Roel

Thank you for helping me out. While that formula shows it next payment date for every deposit, it doesn't solve my problem to see all the future payment dates for all the deposits.

Ideally, I would like to pivot the table that shows all the upcoming payments for all the deposits. It would look something like this:

Table headers:
Date
Bank
Deposit AC number
Payout

It is this table that I want to pivot to create the calendar and apply various slicers. I have slightly edited your excel sheet.