Spreadsheet: 455258d1460194450-summary-ageing-formula-ageing-example
Sheet: Data

FLAT | Date | DUE AMT | TODAY | NO OF DAYS | >120 | 91-120 | 61-90 | 30-60 | 0-30 | FUTURE DUES | Dif
A1004 | 2016-01-15 00:00:00 | 20000 | 2016-04-09 00:00:00
A1004 | 2016-03-31 00:00:00 | 30000 | 2016-04-09 00:00:00
A1104 | 2015-12-15 00:00:00 | 40000 | 2016-04-09 00:00:00
A1104 | 2016-01-12 00:00:00 | 50000 | 2016-04-09 00:00:00
A1105 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A1105 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1105 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1106 | 2016-06-05 00:00:00 |  | 2016-04-09 00:00:00
A1203 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A1203 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1203 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1303 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A1303 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1303 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1306 | 2016-02-15 00:00:00 |  | 2016-04-09 00:00:00
A1401 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A1401 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1401 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1404 | 2016-03-21 00:00:00 |  | 2016-04-09 00:00:00
A1406 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A1406 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1406 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1504 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
A1506 | 2016-01-31 00:00:00 |  | 2016-04-09 00:00:00
A1701 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1706 | 2016-01-18 00:00:00 |  | 2016-04-09 00:00:00
A1801 | 2016-01-25 00:00:00 |  | 2016-04-09 00:00:00
A1803 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A1803 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A1806 | 2016-02-29 00:00:00 |  | 2016-04-09 00:00:00
A301 | 2016-01-31 00:00:00 |  | 2016-04-09 00:00:00
A403 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A403 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A403 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A404 | 2016-04-07 00:00:00 |  | 2016-04-09 00:00:00
A404 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
A505 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A505 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A506 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
A506 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A506 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A601 | 2015-11-30 00:00:00 |  | 2016-04-09 00:00:00
A601 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A601 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A603 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
A603 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A701 | 2016-02-22 00:00:00 |  | 2016-04-09 00:00:00
A703 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
A804 | 2016-02-20 00:00:00 |  | 2016-04-09 00:00:00
A805 | 2016-03-15 00:00:00 |  | 2016-04-09 00:00:00
A904 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
A906 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
B1001 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1004 | 2015-05-31 00:00:00 |  | 2016-04-09 00:00:00
B1103 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1103 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1106 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1106 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1301 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1301 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1303 | 2015-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1303 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1305 | 2016-03-25 00:00:00 |  | 2016-04-09 00:00:00
B1305 | 2016-03-31 00:00:00 |  | 2016-04-09 00:00:00
B1403 | 2015-11-15 00:00:00 |  | 2016-04-09 00:00:00
B1403 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1403 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1406 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1406 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1503 | 2016-03-17 00:00:00 |  | 2016-04-09 00:00:00
B1606 | 2015-06-02 00:00:00 |  | 2016-04-09 00:00:00
B1606 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1701 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1706 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1706 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1801 | 2016-01-31 00:00:00 |  | 2016-04-09 00:00:00
B1803 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1803 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1804 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1804 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B1806 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B1806 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B304 | 2016-02-29 00:00:00 |  | 2016-04-09 00:00:00
B401 | 2016-03-31 00:00:00 |  | 2016-04-09 00:00:00
B401 | 2016-05-31 00:00:00 |  | 2016-04-09 00:00:00
B406 | 2016-03-25 00:00:00 |  | 2016-04-09 00:00:00
B406 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
B406 | 2016-04-30 00:00:00 |  | 2016-04-09 00:00:00
B501 | 2016-04-30 00:00:00 |  | 2016-04-09 00:00:00
B506 | 2016-04-10 00:00:00 |  | 2016-04-09 00:00:00
B601 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
B602 | 2016-01-20 00:00:00 |  | 2016-04-09 00:00:00
B704 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B705 | 2016-03-15 00:00:00 |  | 2016-04-09 00:00:00
B705 | 2016-04-15 00:00:00 |  | 2016-04-09 00:00:00
B801 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B801 | 2016-01-12 00:00:00 |  | 2016-04-09 00:00:00
B902 | 2015-12-31 00:00:00 |  | 2016-04-09 00:00:00
B903 | 2015-01-31 00:00:00 |  | 2016-04-09 00:00:00
B906 | 2016-02-29 00:00:00 |  | 2016-04-09 00:00:00
TOAL