Hi, If I have a start date of 7/4/2016, end date 12/31/18 and I need $15,000 to appear on July 2016, then October 2016, then January 2017, every 3 months until the end date --> what formula does this?
Column A
<tbody>
</tbody>
https://docs.google.com/spreadsheets/d/1uGh3xO0fFdMWzoW6Hjz74zNxjUTSCzLyPdJGY97lrZA/edit?usp=sharing
Column A
Invoice Start Date | Invoice End | Invoice Amount | 7/31/2016 | 8/31/2016 | 9/30/2016 | 10/31/2016 | 11/30/2016 | 12/31/2016 | 1/31/2017 |
7/4/2016 | 12/31/2018 | 15,000 | 15,000 | 15,000 | 15,000 | ||||
7/4/2016 | 12/31/2018 | 15,000 | |||||||
7/8/2016 | 12/31/2018 | 4,000 | |||||||
7/12/2016 | 12/31/2018 | 2,000 |
<tbody>
</tbody>
https://docs.google.com/spreadsheets/d/1uGh3xO0fFdMWzoW6Hjz74zNxjUTSCzLyPdJGY97lrZA/edit?usp=sharing