Automated aging report

  • Thread starter Thread starter michele
  • Start date Start date
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
 
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
 
Back
Top