Account Receivable Aging

[Jason McDermott]

I am trying to do an aging in Excel
Basically If an invoice is between 30 and 60 days old I
want to put the invoice amount in the over 30 day column
if over 60 days it should go in the 60 -90 column.

EX
Invoice # Date Amount over 30 Over 60 over90
425111 8/1/03 $100.00 $100.00

Does anyone know what formula I can put in the over
30 /over 60 ect column so it will look at the date and put
the amount in correct column
Thank you

 

[Peo Sjoblom]

Assume the date starts in B2 and the amount is in C2, in the 30-60 column
use

=IF(AND(TODAY()-B2>30,TODAY()-B2<=60),C2,"")

in the 60-90 column use

=IF(AND(TODAY()-B2>60,TODAY()-B2<=90),C2,"")

and in the over 90 column use

=IF(TODAY()-B2>90,C2,"")