Build an Accounts Receivable Aging Report in Excel

A viewer asked my help in building an A/R Aging Report. She wants to see the total for invoices that are “past due” 1 – 30 days, 31-60 days, etc. In this video I use the =TODAY(), =IF(), =AND() and =WEEKDAY() functions to build this report. If you have an Excel question, send it to me, I will answer it as soon as I possibly can do so. My DVD-ROM, “The 50 Best Tips, Tricks & Techniques for Excel 2007″ is now available for sale. Visit my website – www.thecompanyrocks.com/excels – for details on how to purchase it.
Video Rating: 4 / 5

Dr. Jennifer Ashton offers practical tips on how to slow the appearance of aging.
Video Rating: 5 / 5