Thread: aging formulas
View Single Post
  #1   Report Post  
Susan
 
Posts: n/a
Default aging formulas

I am using Excel to track Accounts Payable for a small company. Column A is
the $ amount of the invoice, Column B is the date of the invoice, Column C is
the due date and columns D,E,F,G....are aging (i.e. 1-30, 31-60, 61-90,
91-120).

Is there a function that will age and move the $$ to the correct column?



Thanks,,,,,,
Susan