Automated aging report

M

michele

Please help...

I am trying to create a formula for accounts receivable
aging.

A B C D E F G H
InvDate OpenAmt Days Curr 30day 31-60days 61-90day 90+

2 2/1/04 $100 2 $100
3 11/16/03 $100 77 $100
4
5

I was able to find a formula for the number of days in
invoice has aged. Column C =DATEDIF(D5,NOW(),"d")

I just can't figure out how to get the open amt to fall
under its appropriate age group.

Thank you in advance for your assistance.

Michele
 
F

Frank Kabel

Hi Michele
enter the following in D2 (that should be the 'Curr 30day' column)
=IF(C2<=30,B2,"")
in E2 enter
=IF(AND(C2>30,C2<=60),B2,"")
in F2 enter
=IF(AND(C2>60,C2<=90),B2,"")
in G2 enter
=IF(C2>90,B2,"")
copy these formulas down

HTH
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top