Overdue Days

[Shan54321]

Hi Friends ,

I have a sheet with detail of ageing but I need in summary sheet the ageing days for each unit.

For Example in Summary tab Royal ageing it should show 61-90 / Over 360 under ageing tab.

Any formula can suggest .

[FDibbins]

show some sample answers in your file please, and explain how you arrive at them

[Shan54321]

Detail Tab is updated manually for each customer's outstanding amount on a monthly basis.

But I need in summary the months to be updated automatically with the help of any formula

[JeteMc]

This proposal employs a number of helpers which may be moved and/or hidden for aesthetic purposes.
On the Detail sheet columns S:AE are populated using: =IF(AND(D3="",R3=""),"",IF(D3="",R3,R3&" / "&INDEX($D$2:$P$2,COLUMNS($A$1:A$1))))
Column AF is populated using: =RIGHT(AE3,LEN(AE3)-3)
On the Summary sheet the Aging column is populated using: =INDEX(Detail!AF$3:AF$5,MATCH(B3,Detail!C$3:C$5,0))
Let us know if you have any questions.