I need formulas. Make it clear please.

Required: 1. Calculate the number of days unpald, USING THE EXCEL DAYS. FUNCTION (6x). 2. Use the information from Requirement 1 to complete the Aging of Accounts Receivable Schedule. 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 NAND function to check for date ranges. For example, =If(AND(E8>30, E8co60).[VALUE if TAUE].[VALUE If FALSE)]) 3. Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the unadjusted balance shown. \begin{tabular}{|l|l|l|l|} \hline 43 & 3. Prepare the adjusting journat entry for recording bad debt expense if the Allow \\ 44 & & & \\ \hline 45 & Allowance for Doubtful Accounts & & \\ \hline 46 & Bad Debt Expense & & \\ \hline 47 & Allowance for Doubtful Accounts & & \\ \hline \end{tabular} 4. Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the unadjusted balance shown. 54 GradedWorksheet