Archives for November 2009

Build an Accounts Receivable Aging Report

Here is another request for help from a viewer. How to create a report that shows “the aging” of past due invoices (1 – 30 days past due, etc.).

Here are the Functions that I use in this report:

  • =IF()
  • =AND()
  • =WEEKDAY()

Looking for a specific Excel video? Take advantage of my Index of Excel Video Lessons to find the video that you want to watch.

Related Videos

You can watch this Excel Video Lesson on YouTube

Invitation to Visit My Online Shopping Site

Want to learn the best Tips for Excel? You can purchase my DVD, “The 50 Best Tips, Tricks & Techniques for Excel 2007

I use a secure shopping cart at – I invite you to pay a visit today!

Click here to see a Listing of “The 50 Best Tips for Excel 2007”