Hi all,
I need to create an overview in which:
1. all payments received in the reporting month are listed in one column
2. expected future payments in monthly columns
| Invoicenumber | paid 2018-01 (reporting month) | 2018-02 | 2018-03 | etc | etc |
|---|
| | | | | | |
Please see attached file
The reasoning is to allocate a (future) payment to a column by defining an additional date. The logic could be something like
IF(Pay_date<>0 than Pay_date = Payment_Date,
Elseif(Rep_Date>Due_date than Rep_Date+45= Payment_date ;
Else (Due_date+15= Payment_date)
How should I do this?
