I want looking to make an age trial balance sheet base on account receivable
for a company - they want it done in excel but I can't figure it out... How
can I make an invoice for example aged accordingly for example invoice was
created last month therefore within my aging it should fall into the 1-30
days bucket..
buckets 31-60 - 61-90- 91-120 - over 120 days are the other buckets

"Anne Troy" wrote:

Hi, Anne. :)
We'll need more information than that, such as what cells your due dates are
in, how many days out they go before they're "aged" and how many agings you
want, etc.
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


"Anne L" <Anne wrote in message
...
Can anyone help? I am trying to create an age trial balance sheet in
Excel,
however can't get it to age accordingly.