I have two excel reports. Firstly, an accounts receivable report with a column of customer names and columns with terms such as "Current", 1-30, 30-60, etc. Secondly, I have a sheet with a column of customer names with a second column of their "average days to pay"

I would like to have these two sheets to compare the customer names so that a particular customer's average days to pay lines up with their accounts receivable information.

My ultimate goal is to have an accounts receivable report that will tell me when we can expect a customer's AR to come in.

I have the sheets available.
HCCI Average Days To Pay.xlsx
HCCI AR.xlsx

Thanks in advance!

Chris Bertolini
Newland, NC