show calculations

Required: 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 rankes. For example. =IF(AND(E8 >30,E8