Hello friends, I need to construct aging receivables with formula. In my workbook in the first sheet, there is credit and debit movement with specific accounts. And in a sheet2 opening and closing balance of this accounts. My question is how to construct aging receivables in sheet3 so that first opening balances were eliminated, then oldest accruals and what is left to show in sheet 3 with days increment .... thanks in advance.
Bookmarks