From the calculation below, when the two (2) dates in cell C19 and D19 are subtracted, it returns a value of 62 days, which is in the range of cell B8 (70 - 61 days). Now, the problem is getting the amount in cell F19 ($50,000.00) to automatically sort itself into the array of cells in column C (i.e. C5 - C14).
Bookmarks