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

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

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=376631

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

thanks

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


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Soniya" wrote in message
oups.com...
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