Required: 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). Customer Fitness Mania Health for Life Holistic Health Options Image Reimaging Today's Gym World Whole Life Fitness Center Workouts Unlimited Total $ $ Amount 2,500 2,000 12,750 7,000 4,600 15,900 3,800 48,550 Invoice Date 6/17/2016 12/21/2016 10/12/2016 12/5/2016 11/29/2016 11/20/2016 10/2/2016 Today's Date 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 12/31/2016 Number of Days Unpaid 197 10 80 26 32 41 90

Please tell me what the excel functions you used are thank you :)

Required: 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). 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 ea customer amount belongs