Number of days past due

Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toots credit terms are n/30. As of the end of business on October 31, the following accounts receivable were past due:

Account	Due Date	Amount
Avalanche Auto	August 20	$12,000
Bales Auto	October 7	2,400
Derby Auto Repair	June 21	3,900
Lucky's Auto Repair	September 7	6,600
Pit Stop Auto	September 24	1,100
Reliable Auto Repair	July 1	9,750
Trident Auto	August 25	1,800
Valley Repair & Tow	May 23	4,000

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Determine the number of days each account is past due as of October 31. Round your answers to the nearest whole number.

Account	Due Date	Number of Days Past Due
Avalanche Auto	August 20	fill in the blank 2
Bales Auto	October 7	fill in the blank 3
Derby Auto Repair	June 21	fill in the blank 4
Lucky's Auto Repair	September 7	fill in the blank 5
Pit Stop Auto	September 24	fill in the blank 6
Reliable Auto Repair	July 1	fill in the blank 7
Trident Auto	August 25	fill in the blank 8
Valley Repair & Tow	May 23	fill in the blank 9

Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toot's credit terms are n/30. As of the end of business, the accounts receivable provided below were past due. Using formulas and cell references, perform the required analysis, and input your answers into the Number of Days Past Due column. Transfer the numeric result for the green entry cells (D10:D17) into the appropriate fields in CNOWv2 for grading