I need more help with the EXCEL "IF", etc. formulas

Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The Controller has asked you to help prepare the Aging of Accounts Receivable Schedule and the corresponding journal entries. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

please help!

You received part A C E Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. 1 3 Required: 4 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). 5 6 Number of Days Unpaid 197 Invoice Date Today's Date 12/31/2016 12/31/2016 12/31/2016 12/31/2016 Customer Amount 6/17/2016 12/21/2016 10/12/2016 12/5/2016 11/29/2016 8 Fitness Mania 2,500 2,000 12,750 7,000 4,600 15,900 $ 10 80 9 Health for Life 10 Holistic Health Options 11 Image Reimaging 12 Today's Gym World 13 Whole Life Fitness Center 26 12/31/2016 32 12/31/2016 12/31/2016 11/20/2016 41 10/2/2016 90 3,800 14 Workouts Unlimited 1 of 1 Next Prey NOV P w X 30 19 The IF statement may include the following arguments: ,>=, ,>=,