Here is what my spreadsheet looks like
I enter recurring weekly payments details in G,H,I,J & K (Name,Amount,Day of week, Start Date, End Date respectively). This arrayformula:
shows the amount due (D), on the Date (A), whose day of the week (C) matches the one defined in I.
If I have something that will be due every Friday for example I put the name for the bill in G, the amount in H, and the day of the week # in I. When I do that column D shows amount that is due and repeats it on all the dates where column C (DOW#) match the provided value in column I.
What I would like to do is
make column D not add the amount if the date in A is before the date in column J or after the date in column K. It should work if neither J or K have values, if J has a value, if K has a value or if both J & K have a value.
All my attempts at figuring out how to compare the dates with gt (>) & lt (<) in the same arrayformula have failed.