Ageing solution require

[Ketan_ashiyani]

Dear Team,

we need to solution require for ageing in excel.

Data Base	01 to 30	31 to 60	60 to 90	90 to 120	120 to 180	180 above	Total
	100	300	400	-547	150	1000	1403
Requirement	01 to 30	31 to 60	60 to 90	90 to 120	120 to 180	180 above	Total
	100	300	400	0	150	453	1403

 

[Joe4]

Can you explain in more detail?
Can you walk us through an actual example with expected results?