I WANT FORMULA FOR THIS DISTRIBUTION | |||||||
Invoice-01 | Invoice-02 | Invoice-03 | Invoice-04 | ||||
Duration-45 days | 26-Nov-17 | 26-Dec-17 | 26-Jan-18 | ||||
Erected Date | Bill From | To Date | 25-Nov-17 | 25-Dec-17 | 25-Jan-18 | 25-Feb-18 | The Payable Rental Days are From Erected date +45 On wards Only |
20-Sep-17 | 26-Jan-18 | 31-Jan-18 | 22 | 30 | 31 | 6 | |
4-Oct-17 | 26-Jan-18 | 25-Feb-18 | 8 | 30 | 31 | 31 | |
5-Oct-17 | 26-Jan-18 | 1-Feb-18 | 7 | 30 | 31 | 7 | |
9-Oct-17 | 26-Jan-18 | 25-Feb-18 | 3 | 30 | 31 | 31 | |
9-Oct-17 | 26-Jan-18 | 29-Jan-18 | 3 | 30 | 31 | 4 | |
9-Oct-17 | 26-Jan-18 | 26-Jan-18 | 3 | 30 | 31 | 1 | |
11-Oct-17 | 26-Jan-18 | 25-Feb-18 | 1 | 30 | 31 | 31 | |
11-Oct-17 | 26-Jan-18 | 25-Feb-18 | 1 | 30 | 31 | 31 | |
11-Oct-17 | 26-Jan-18 | 25-Feb-18 | 1 | 30 | 31 | 31 | |
15-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 27 | 31 | 31 | |
15-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 27 | 31 | 31 | |
16-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 26 | 31 | 31 | |
24-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 18 | 31 | 31 | |
24-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 18 | 31 | 31 | |
25-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 17 | 31 | 31 | |
25-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 17 | 31 | 31 | |
26-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 16 | 31 | 31 | |
26-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 16 | 31 | 31 | |
29-Oct-17 | 26-Jan-18 | 26-Jan-18 | 0 | 13 | 31 | 1 | |
31-Oct-17 | 26-Jan-18 | 25-Feb-18 | 0 | 11 | 31 | 31 | |
1-Nov-17 | 26-Jan-18 | 31-Jan-18 | 0 | 10 | 31 | 6 | |
1-Nov-17 | 26-Jan-18 | 31-Jan-18 | 0 | 10 | 31 | 6 | |
1-Nov-17 | 26-Jan-18 | 25-Feb-18 | 0 | 10 | 31 | 31 | |
4-Nov-17 | 26-Jan-18 | 1-Feb-18 | 0 | 7 | 31 | 7 | |
5-Nov-17 | 26-Jan-18 | 28-Jan-18 | 0 | 6 | 31 | 3 | |
9-Nov-17 | 26-Jan-18 | 28-Jan-18 | 0 | 2 | 31 | 3 | |
12-Nov-17 | 26-Jan-18 | 25-Feb-18 | 0 | 0 | 30 | 31 | |
12-Nov-17 | 26-Jan-18 | 25-Feb-18 | 0 | 0 | 30 | 31 |
<colgroup><col><col><col><col><col span="3"><col></colgroup><tbody>
</tbody>