Title:
Build an Accounts Receivable Aging Report in Excel
Video:
Description: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 and Techniques for Excel 2007" is now available for sale. Visit my website - www.thecompanyrocks.com/excels - for details on how to purchase it.
Published:
01/Nov/2009
Build an Accounts Receivable Aging Report in Excel
Video:
Description: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 and Techniques for Excel 2007" is now available for sale. Visit my website - www.thecompanyrocks.com/excels - for details on how to purchase it.
Published:
01/Nov/2009
No comments:
Post a Comment