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”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. Need Aging Sample

  2. Give me a few days and I will post the sample worksheet that I used for this lesson on my SkyDrive at

    Danny Rocks

  3. This explanation made my life at work so much easier!!!!
    Thank you so very much!!!!!

  4. Thank you for adding your comment. I am delighted that I could help you!

    Danny Rocks

Speak Your Mind