After an initial investment is made (M7) and it accrues interest to a certain amount (T9 table) you can re-invest it. Different amounts are held for different times until it is then released. I need the amounts released to show on the certain day they are released.
I included a blue table in the worksheet (sheet 1010) that explains more specifically. I'm pretty sure the formula should be sumproduct and offset, but I'm not entirely sure. Any help would be appreciated.
https://drive.google.com/file/d/1qy-IeFSA8p_JjF_OLnJbZRDzZ-tFIzXD/view?usp=sharing
I included a blue table in the worksheet (sheet 1010) that explains more specifically. I'm pretty sure the formula should be sumproduct and offset, but I'm not entirely sure. Any help would be appreciated.
https://drive.google.com/file/d/1qy-IeFSA8p_JjF_OLnJbZRDzZ-tFIzXD/view?usp=sharing