Please help me, I need to know what is the formula for the Aging of Accounts Receivable Schedule and for the journal entry.

2. Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. 4 Required: 5 1) Calculate the number of days unpaid, using the Excel DAYs function. 2) Use the information above to complete the Aging of Accounts Receivable Schedule below. Create a formula for each age category, using the Excel if function to determine where each customer amount belongs. Calculate each "Total" cell by using the Excel SUM function and include all possible cells. Leave no cells blank. HINT: Use the = AND function to check for date ranges. For example, =1F(AND(E8>30,E8