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.
riverhousefoto
2 years ago
excellent tutorial, thanks.
DannyRocksExcels
2 years ago
@riverhousefoto
Thank you – I am pleased that you found this lesson helpful.
Danny Rocks
judzm
1 year ago
Very informative lessons on excel. You Rock Danny!
DannyRocksExcels
1 year ago
@judzm
Thank you for writing, I am pleased that you found the video informative.
Danny Rocks
The Company Rocks