I’m trying to do something really simple but failing. I’ve got a list of loans and each loan has a starting date. Interest is payable every x months from the starting date. I want to create a Boolean every x months from the starting date. How do I do this? I can put a boolean in the first repayment date but then I’m failing.
Loan 1 has a start date of 11 March 2020 and interest is payable every 3 months. I want a tick in 11 June 2020, 11 Sep 2020, 11 Dec 2020, 11 March 2021 etc.
Loan 2 has a start date of 20 November 2019 and interest is payable every 5 months. I want a tick in 20 Apr 2020, 20 Sep 2020, 20 Feb 2021 etc.
Time scale - In days