1 C23 A X AND(E30) 2 100 pon S 41) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION Xercise Cycles Company sells exercise equipment to gym on account. At year end, the following accounts receivable were uncollected 1 Required E 7 Customer Amount Invoice Date Today's Date Number of Days Unpaid Pine Fitness Mania S References 10 Holistic Health Options Health for Life 2,500 2,000 6/17/2016 12/31/2016 197 12/21/2016 12/31/2016 10 12,750 10/12/2016 12/31/2016 11 Image Reimaging 7,000 12/5/2016 12/31/2016 26) 12 Today's Gym World 4,600 13 Whole Life Fitness Center 15.900 11/29/2016 12/31/2016 11/20/2016 32 14 Workouts Unlimited 3.800 12/31/2016 10/2/2016 12/31/2016 41 15 Total 48,550 17 21 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 Customer Sheet1 READY 0/3 0-30 Number of Days Unpaid 31-40 61.00 Over 30 Help Save & Exit