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 http://shop.thecompanyrocks.com – I invite you to pay a visit today!
Click here to see a Listing of “The 50 Best Tips for Excel 2007″
November 1st, 2009 at 11:53 AM
[...] Build an Accounts Receivable Aging Report [...]
May 16th, 2010 at 12:06 PM
[...] Build an Accounts Receivable Aging Report [...]
September 25th, 2010 at 10:52 AM
[...] Build an Accounts Receivable Aging Report [...]
March 13th, 2011 at 11:08 AM
[...] 2- Build an Accounts Receivable Aging Report [...]
June 18th, 2011 at 8:31 AM
Need Aging Sample
June 20th, 2011 at 8:34 AM
Give me a few days and I will post the sample worksheet that I used for this lesson on my SkyDrive at http://www.office.live.com
Danny Rocks
September 26th, 2011 at 11:39 AM
This explanation made my life at work so much easier!!!!
Thank you so very much!!!!!
September 26th, 2011 at 11:41 AM
Thank you for adding your comment. I am delighted that I could help you!
Danny Rocks