Automated aging report

[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

 

[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