Home / Expert Answers / Accounting / please-show-excel-formulas-will-like-1-calculate-the-number-of-days-unpaid-using-the-excel-pa754

# (Solved): Please show excel formulas!!!!! Will like 1) Calculate the number of days unpaid, USING THE EXCEL ...

Please show excel formulas!!!!! Will like

1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). \begin{tabular}{|l|r|r|r|r|} \hline \multicolumn{1}{|c|}{ Customer } & & & & \\ \hline Fitness Mania & \multicolumn{1}{|c|}{ Amount } & Invoice Date & Today's Date & 197 \\ \hline Health for Life & 2,500 & & & 10 \\ \hline Holistic Health Options & 2,000 & & & 80 \\ \hline Image Reimaging & 12,750 & & & 26 \\ \hline Today's Gym World & 7,000 & & & 32 \\ \hline Whole Life Fitness Center & 4,600 & & & 41 \\ \hline Workouts Unlimited & 15,900 & & & 90 \\ \hline Total & 3,800 & & & \\ \hline \end{tabular} 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 and AND FUNCTIONS (fx) to determine where each customer amount belongs. The IF statement may include the following arguments: , Excel AND FUNCTION (fx).

We have an Answer from Expert

We have an Answer from Expert