Aging Function

[hrhusker]

I have a column that lists what is owed on an invoice. If the cell is 0, I do not want anything listed in the aging cell. However, if there is a dollar amount, I want it to take the current date and subtract the invoice date to get the aging.

I have been successful in getting it to recognize the first part of the function but not to do the calculation for the second half.

[Alex Delamain]

If the invoice date is in column A and the amount outstanding in column B then in col C

=IF(B1>0,+TODAY()-A1,"")

[hrhusker]

Thank you very much for the previous formula, it worked perfectly!

Now that I have the number of days an invoice is late, I need to move them to another section of the worksheet that breaks it down between current, 30 days, 60 days, 90 days and 120+. I also need it to add the amount due for each amount past due.