Aging Accounts Receivable Reports on Multiple Sheets With Array Formula

min) Overview of end result: Automatic Aging Reports.
min) Convert Source Data Table (in separate workbook file) to an Excel Table and name the Table..
min) Import Source Data into Report File.
min) Add Helper Column to Destination Excel Table in the Report Workbook file. First look at Table Formula Nomenclature (Structured References). The correct formula for Days Late is: =TODAY()-[@[Due Date]]..
min) COUNTIFS formula to count records that are between 1 and 30 days past due. Including syntax for greater than or equal to criteria when the comparative operator and a cell must be joined..
min) Array Formula to extract the "Number of Days Late" information for each customer, given two criteria. See how to use LARGE function and IF function and the array formula key stroke: Ctrl + Shift + Enter. GOOD FOR EXCEL 2007 or EARLIER. Learn more about Table Formula Nomenclature (Structured References)..
min) See how to use IF function rather than IFERROR function to create efficient Data Extraction Array Formulas..
min) Array Formula to extract the "Number of Days Late" information for each customer, given two criteria. See how to use the AGGREGATE function rather than the LARGE function to gain the benefits: 1) No need for special keystroke, 2) avoid errors from implicit intersection. GOOD FOR EXCEL 2010 or LATER..
min) Array Formula to extract Customer Name and Invoice Amount using INDEX, AGGREGATE, IF, ROW, COUNTIFS and ROWS functions..
min) Learn how to make Table Formula Nomenclature (Structured References) Absolute..
min) Copy Array Formula Reprt to Multiple Sheets..
min ) Test to see if data changed in the Source and Destination workbooks will be reflected in the Aging Reports automatically..