Hello
I am trying to create a formula that shows the overdue amount based on amount of days overdue. In this case i am looking to sum up the values that are overdue more than 8 to 14 days. The cells that are overdue are marked with a negative sign.
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I am trying to create a formula that shows the overdue amount based on amount of days overdue. In this case i am looking to sum up the values that are overdue more than 8 to 14 days. The cells that are overdue are marked with a negative sign.
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>
Due date | Amount | Today | Days overdue | |||
2018-09-26 | 10 000 | 2019-06-03 | -250 | overdue > 8-14 days | Due in 15 days | |
2019-05-13 | 9 434 | 2019-06-03 | -21 | Amount? | Amount? | |
2019-05-15 | 3 053 | 2019-06-03 | -19 | |||
2019-05-20 | 6 000 | 2019-06-03 | -14 | |||
2019-05-23 | 65 077 | 2019-06-03 | -11 | |||
2019-05-24 | 69 350 | 2019-06-03 | -10 | |||
2019-05-24 | 2 500 | 2019-06-03 | -10 | |||
2019-05-27 | 3 000 | 2019-06-03 | -7 | |||
2019-05-27 | 18 253 | 2019-06-03 | -7 | |||
2019-05-29 | 40 039 | 2019-06-03 | -5 | |||
2019-05-29 | 33 108 | 2019-06-03 | -5 | |||
2019-06-12 | 3 153 | 2019-06-03 | 9 | |||
2019-06-13 | 39 930 | 2019-06-03 | 10 | |||
2019-06-13 | 18 795 | 2019-06-03 | 10 | |||
2019-06-14 | 17 000 | 2019-06-03 | 11 | |||
2019-06-14 | 37 546 | 2019-06-03 | 11 | |||
2019-06-17 | 10 000 | 2019-06-03 | 14 | |||
2019-06-17 | 57 219 | 2019-06-03 | 14 | |||
2019-06-19 | 3 125 | 2019-06-03 | 16 | |||
2019-06-19 | 24 079 | 2019-06-03 | 16 | |||
2019-06-19 | 22 216 | 2019-06-03 | 16 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>