Aging Calculation

[Soniya]

Hi All,

I have the folowing in my sheet1

balance as on balance as on balance as on
Clnt name 31-1-2004 28-2-2004 ........ 31-5-2005

Clnt1 10000 25000 25000
clnt2 1200 500 1200
clnt3... 700 12000 7000 ....

how can i make an aging calculation from above..

like as on 31-5-2005 current, 30 days, 60 days, 90 days 120 days etc

TIA
Soniya

 

[mangesh_yadav]

Could you clarify further. What is your expected answer for say current,
and for 30 days, for client 1.

Mangesh

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/ageing.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

Ageing analysis of data without using VBA

 

[Soniya]

it was a mistake....
what i want is to get 1-30 days and 31-60 days and 61-90 days etc..

thanks