Let’s work on an example of building a dynamic AR aging schedule in Excel. If you would like to follow along, you can download this Excel workbook and access a video at the bottom of this article.

Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists with all the choices. Let’s work on a few examples using the AGGREGATE function. If you would like to ...